IF Formula with Multi Value

Hello everyone. Am a basic excel user and need help in this requirement. I have huge and need to

Condition is, if Cell A1 having the value P1 and A2 is >= 30 then result is Compliant else Noncompliant, if Cell A1 having the value P2 and A2 is >= 60 then result is Compliant else Noncompliant, if Cell A1 having the value P3 and A2 is >= 90 then result is Compliant else Noncompliant

A sample sheet might help (see banner... top).... but try:

=IF(OR(AND(A1=P1,A2>=30),AND(A1=P2,A2>=60),AND(A1=P3,A2>=90)),"Compliant","Non-compliant")

thanks for the quick help Glenn this worked.
=IF(OR(AND(A1="P1",A2>="30"),AND(A1=P2,A2>="60"),AND(A1="P3",A2>=90)),"Non-Compliant","Compliant")

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.