Why does blank text equal 0?
I have a spreadsheet where in some cells I want the cell to show
nothing if a condition is not met:
For example, in cell A1:
= IF (a = b, a + b, "")
If in A2 when a<b, I check to see if this value is greater than 0, it
returns TRUE:
= A1 0
I can even simplify A1 just to be:
= ""
and the it still returns that this cell 0.
Can someone please explain and maybe offer an alternative way to
display nothing in a cell that will register as a 0?
Thanks.
John
|