I am trying to combine the 2 IF statements below into 1. Can you tell me the combined syntax when trying to combine the 2?

=IF(AND(C5="Non-eng",P5>=2,N5>=0),"Met","Not Met")
=IF(AND(C5="Eng",N5>=1,P5>=1),"Met","Not Met")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.