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