View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] robotman@gmail.com is offline
external usenet poster
 
Posts: 73
Default 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