IFStatement w/ Nested AND and OR

S

stan

Hi Gurus.I have 3 columns tracking status - A,B,C. The value in
each column can be 'x' or blank. I am trying to create
an IF Statement that will return True if column A equals x
AND if either column B OR C equals x.

Thank you for your guidance.
This one did not work: =IF(AND(A1="x",OR
Click to expand...
B1="x",C1="x")),ValueIfTrue,ValueIfFalse)
 
D

Dan E

Stan,

One way to accomplish your goal

=CHOOSE(MATCH(MIN(A2:D2),A2:D2,0),"Rate A","Rate B","Rate C","Rate D")

MATCH(MIN(A2:D2),A2:D2,0) will return the index number of the lowest value
The CHOOSE statement will pick the result based on the MATCH

Dan E
 
D

Dan E

Stan,

=IF(AND(A1 = "x", OR(B1 = "x", C1 = "x")), "True", "False")

You had incorrect brackets around you OR statement

Dan E
 
D

Dan E

Stan,

I tested it and it worked for me... I set it up as follows

A B C D
x x x =IF(AND(A1 = "x", OR(B1 = "x", C1 = "x")), "True", "False")
SAMPLE RESULTS
x x y True
x y x True
x y y False
y x x False

Dan E
 

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

Nesting AND/OR into IF Funtion 3
SUMIF "value if false" not working 2
converting text to numbers 4
converting text to numbers 4
Formula Needed for Corresponding Blank Cell 1
Determine if a month falls between two dates. 5
SUMIF and AND/OR/NOT 7
How to write an Or statement inside Sumproduct? 4

Top