Get rid of FALSE in cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StargateFanFromWork - 20 Sep 2007 20:27 GMT

How do we get rid of the FALSE in a cell, pls? The cell in question, N2,
has this formula in it:

=IF(K3<>"",IF(M2=0,"OKAY","RE-CHECK"))

When K3 is empty, I get a FALSE rather than just a blank cell.

Thank you! :oD

Reply to this Message

Peo Sjoblom - 20 Sep 2007 20:38 GMT

=IF(K3<>"",IF(M2=0,"OKAY","RE-CHECK"),"")

Signature

Regards,

Peo Sjoblom

> How do we get rid of the FALSE in a cell, pls? The cell in question, N2,
> has this formula in it:
[quoted text clipped - 4 lines]
>
> Thank you! :oD

Reply to this Message

Sandy Mann - 20 Sep 2007 20:41 GMT

Try:

=IF(K3="","",IF(M2=0,"OKAY","RE-CHECK"))

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> How do we get rid of the FALSE in a cell, pls? The cell in question, N2,
> has this formula in it:
[quoted text clipped - 4 lines]
>
> Thank you! :oD

Reply to this Message

JE McGimpsey - 20 Sep 2007 20:42 GMT

One way:

You have to provide an alternative to the default FALSE branch. One
option is to use the null string (""):

=IF(K3<>"",IF(M2=0,"OKAY","RE-CHECK"),"")

or, equivalently:

=IF(K3="","",IF(M2=0,"OKAY","RE-CHECK"))

> How do we get rid of the FALSE in a cell, pls? The cell in question, N2,
> has this formula in it:
[quoted text clipped - 4 lines]
>
> Thank you! :oD

Reply to this Message

Rate this thread: