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

Hi

Maybe your first IF formula has a true option:
=IF(A2=10,"","False")

Andy.

"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???

Thank You!


--
pmguerra
------------------------------------------------------------------------
pmguerra's Profile:
http://www.excelforum.com/member.php...o&userid=14986
View this thread: http://www.excelforum.com/showthread...hreadid=548586