ExcelBanter - result if a condition is NOT true?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - result if a condition is NOT true? (https://www.excelbanter.com/excel-worksheet-functions/133696-result-if-condition-not-true.html)

ROland

result if a condition is NOT true?

How do I get XL to report the value of a cell if a (text) value in another
cell is NOT true?

Mike

result if a condition 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

"Roland" wrote:

How do I get XL to report the value of a cell if a (text) value in another
cell is NOT true?

joel

result if a condition is NOT true?

To compare text (not boolean true or false) then you need to use strcomp().

"Roland" wrote:

How do I get XL to report the value of a cell if a (text) value in another
cell is NOT true?

All times are GMT +1. The time now is 11:15 AM.