Get rid of FALSE in cell?

[StargateFanFromWork]

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! D

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[Sandy Mann]

Try:

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

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk

 

[JE McGimpsey]

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