Forum Discussion

Mike Button's avatar
Mike Button
Copper Contributor
Apr 28, 2022
Solved

Nested If statement help

I know this is/has been asked a thousand times but having problems getting my head around this, it is simple I know but driving me nuts.   I have column A that has a Value X, Y or Z, then Column B,...
excel
Formulas and Functions
  • Mike Button's avatar
    Mike Button
    Apr 28, 2022
    Got it figured out:
    =IF(OR(AND(A2>="Y", B2<=30), AND(A2<>"Y", B2<=120)), "Met", "Miss")
Mike Button's avatar
Mike Button
Copper Contributor
Apr 28, 2022
I should note, I have the basic equation so far just not sure how to add in the 2nd criteria
=IF(AND(A2="Y", B<0.31), "Met", "Miss")

Resources