Forum Discussion
Solved
IF using both AND and OR with variable entries
I've looked through quite a few similar posts but haven't found one that matches what I want to do. In column B, there are 4 choices that can be input - O, M, A, E In column F, amounts will be manu...
In O5:
=IF(OR(AND(B5="O",F5<=1999.99),AND(B5="M",F5<=7999.99),AND(B5="A",F5<=4999.99),AND(B5="E",F5<=999.99)),"Not Required","")
Fill down.
In O5:
=IF(OR(AND(B5="O",F5<=1999.99),AND(B5="M",F5<=7999.99),AND(B5="A",F5<=4999.99),AND(B5="E",F5<=999.99)),"Not Required","")
Fill down.
Ooof! I was so close. Thank you! This worked great.