Show blank and not zero

  • Thread starter Thread starter Kevin McCartney
  • Start date Start date
K

Kevin McCartney

Hi, if a cell (B1) references another cell (A1) and A1 is
empty (ISBLANK) B1 shows a zero, if I then reference B1 in
C1 with =IF(ISBLANK(B1);TRUE;FALSE) the results is False
so my question is how do I may B1 blank and not zero.

regards
KM
 
Kevin, like this, =IF(ISBLANK(A1),"",A1)

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Kevin,

you could use somehting like this in B1
=if(a1="","",1)

However, that really wont help the second part of your
query, as ISBLANK(B1) will still return False because the
cell isn't empty, you've just fomratted your results to
make it look empty!

What are you actully trying to do? As the value of C1 is
dependent in some way on A1, wouldn't it be best just to
test that directly?

Pete
 
Back
Top