result if a condition is NOT true?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get XL to report the value of a cell if a (text) value in another
cell is NOT true?
 
In any cell will check if A1 is false and if true return the value of A2 or
unspecified if false.

=IF(A1=FALSE,A2,"Unspecified")

Mike
 
To compare text (not boolean true or false) then you need to use strcomp().
 
You must log in or register to reply here.

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

Excel VBA 1
Excel functions 0
How to use the Stop If True Condition for highlight cells 1
Conditional Format - using 3 different cells conditions together 4
If function with format 1
IF statements 1
Excel conditional formatting with Weeknum 4
Testing for conditions with IF statement and AND function 1

Back
Top