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