Get rid of FALSE in cell?

  • Thread starter Thread starter StargateFanFromWork
  • Start date Start date
S

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! :oD
 
Try:

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

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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"))
 
Back
Top