TEXT will always evaluate to be greater than ANY number. What you can do is
test the blank/empty cell to see if it actually contains a number:

=AND(ISNUMBER(A1),A10)

Biff

wrote in message
ups.com...
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