IFStatement w/ Nested AND and OR

  • Thread starter Thread starter stan
  • Start date Start date
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)
 
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
 
Stan,

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

You had incorrect brackets around you OR statement

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
 
Back
Top