(B2-A2)=0; How to get a blank and NOT '0'
On Jul 29, 7:08�pm, "JoeU2004" wrote:
<snip
Alternatively, simply use =B2-A2 and create the custom format
"General;-General;" without quotes. �You can replace "General" with whatever
numeric format you wish, e.g. "0.00;-0.00;" for the equivalient of Number
with 2 decimal places, but blank for zero.
<snip
Is that so ? Maybe in later versions of Excel but my Excel 97 needs
the third specification to show zero. ie . . .
0.00;-0.00;""
The first element is the format for positive values, the second is for
negative values and the third is for zero values.
Strings in the format specifier are useful for special displays.
eg . . .
"Pay �"0.00;"Refund �"0.00;"Nothing to pay"
.. . . instead of using a function formula to generate alternative cell
display strings.
Alan Lloyd
|