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.
 

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

Scrabble Value calculation for Welsh words 0
Ms Excel Multiple Logical Test Function 0
Nested If/And/Or statements 4
SUMIF "value if false" not working 2
Logical formatting for multiple values 1
Return result of IF logical test in a different cell 1
Excel functions 0
Nested IF statement 5

Back
Top