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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error msg in function .... any ideas???? 7
PLEASE HELP! need conditional formatting related to date, blank cellsand today's date 16
defined name - offset problem 5
Hiding a Zero Result 5
Zero in the cell instead of some junk date 2
Changing this formula? 8
FALSE Statement 2
Getting Rid of Zeros 2

Back
Top