Nested Logical Statements:

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 !!
 
F

Felipe

=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...
 
N

North Shore Willy

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

VBA Coding Help for Beginner 0
Newbie Help - IF Yes No Function 0
Page numbering with Merged Document and IF statements 1
"Fields Nested Too Deeply" Error in Simple Word Document 5
Logical formatting for multiple values 1
SUMIF "value if false" not working 2
If Not blank - Formula for two cells 0
Nested If/And/Or statements 4

Top