View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default TRUE condition???

"pmguerra" wrote in
message ...

Hi

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

=A10

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

Any explanations???


Blank is different from empty.
You may want something like
=AND(A10,A1<"")
--
David Biddulph