Forum Discussion
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,...
- Got it figured out:
=IF(OR(AND(A2>="Y", B2<=30), AND(A2<>"Y", B2<=120)), "Met", "Miss")
Got it figured out:
=IF(OR(AND(A2>="Y", B2<=30), AND(A2<>"Y", B2<=120)), "Met", "Miss")
=IF(OR(AND(A2>="Y", B2<=30), AND(A2<>"Y", B2<=120)), "Met", "Miss")
Good job!
There's a minor extraneous character in your formula. You can take it out with no adverse effect.
=IF(OR(AND(A2>="Y", B2<=30), AND(A2<>"Y", B2<=120)), "Met", "Miss")
After all, there's no such thing as "greater than 'Y'". it either equals "Y" or it doesn't, and you have those two possibilities covered.