View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin McCartney[_2_] Kevin McCartney[_2_] is offline
external usenet poster
 
Posts: 32
Default 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