=IF(AND(OR(A1="Pass",A1="Exempt"),OR(A2="Pass",A2= "Exempt")),"FULL AWARD","")

Regards,
Stefi

€žk11ngy€� ezt Ã*rta:

Hi

I need to Nest If/And/Or together and having trouble

I need to:

If A1=Pass or Exempt and A2 = pass or exempt, FULL AWARD, else ""

Cant seem to fathom this one

Thanks for help