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")
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")
Regards
Dhilip
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks