Show blank and not zero

[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

 

[Paul B]

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 **

 

[Pete McCosh]

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

 

[Tom Ogilvy]

But he could use the same test for B1 that you show for A1.