Is it possible to perform the following calculation? (I hope it's not too
confusing).

IF(AND(A2="Compliant",A3="Compliant")OR(A2="Compli ant",A3="Not
Counted"),"Compliant","")

I have 9 seperate conditions but only three possible outcomes and you can
only nest up to 7. The conditions are the following:

A2, A3 (outcome on the three are all Compliant)
Compliant, Compliant
Compliant, Not Counted
Not Counted, Compliant

A2, A3 (outcome on all five are all Non Compliant)
Non Compliant, Non Compliant
Non Compliant, Compliant
Compliant, Non Compliant
Non Compliant, Not Counted
Not Counted, Non Compliant

A2, A3 (this is the only that equals Not Counted)
Not Counted, Not Counted

Thanks for the help.
Frank