Custom format that shows blank cell if another cell is empty
 

I have a formula in A1, just referrencing to B1 (=B1)
I need to setup following custom format to A1:
If B1 is blank, show blank in A1
If B1 is is 0, show 0 in A1.
If B1 is positive, show the positive in A1.
I have a problem, that blank and zero behave same, so when B1 is
blank, I get always 0 instead of blank.
Is it possible using customer format, not formula (if-then)?
Thank you
Zdenek Moravec

Formula will do it

=IF(B1="","",IF(B1=0,0,IF(B10,"+ve","")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Zdenek Moravec" wrote in message
om...
I have a formula in A1, just referrencing to B1 (=B1)
I need to setup following custom format to A1:
If B1 is blank, show blank in A1
If B1 is is 0, show 0 in A1.
If B1 is positive, show the positive in A1.
I have a problem, that blank and zero behave same, so when B1 is
blank, I get always 0 instead of blank.
Is it possible using customer format, not formula (if-then)?
Thank you
Zdenek Moravec