Show blank and not zero
 

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

Show blank and not zero
 

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 McCartney" wrote in message
...
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

Show blank and not zero
 

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

-----Original Message-----
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
.

Show blank and not zero
 

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

--
Regards,
Tom Ogilvy

"Pete McCosh" wrote in message
...
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

-----Original Message-----
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
.