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???
Thank You!
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???
Thank You!
Hi
Maybe your first IF formula has a true option:
=IF(A2=10,"","False")
Andy.
"pmguerra" <[email protected]> wrote in
message news:[email protected]...
>
> 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???
>
> 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
>
"pmguerra" <[email protected]> wrote in
message news:[email protected]...
>
> 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???
Blank is different from empty.
You may want something like
=AND(A1>0,A1<>"")
--
David Biddulph
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks