Nested Logical Statements:

  • Thread starter Thread starter CARLOS
  • Start date Start date
C

CARLOS

I am trying to write a formula that will do the following:

Return TRUE if the value in A1<>X OR the value in B1<>"YES"

Thanks.

BTW. This site has been very helpful !!
 
=OR(A1<>"X",B1<>"YES")

Regards,
Felipe
-----Original Message-----
I am trying to write a formula that will do the following:

Return TRUE if the value in A1<>X OR the value in
Click to expand...
 
Carlos:

Try this formula in any cell other than A1 or B1:

=IF(AND(A1<>"X",B1<>"YES"),"TRUE","FALSE")

I assume you want a string answer result in the test
formula cell.
 
Back
Top