TRUE condition???

P

pmguerra

Hi

I have an IF formula in one cell which returns "" (blank) if th
condition is true. But if I use, in another cell:

=A1>0

where A1 is my first cell, theoretically blank, it returns TRUE...

Any explanations???

Thank You
 
D

David Biddulph

pmguerra said:
Hi

I have an IF formula in one cell which returns "" (blank) if the
condition is true. But if I use, in another cell:

=A1>0

where A1 is my first cell, theoretically blank, it returns TRUE...

Any explanations???
Click to expand...

Blank is different from empty.
You may want something like
=AND(A1>0,A1<>"")
 
Top