And because you posted the same question with a different subject line I
wasted my time answering a question you already had an answer to. Please do
not double post the same question it's irritating to those who freely give
their time to help out.

Mike

"k11ngy" wrote:

Thanks VM for your help

Kind regards

Steve

"Stefi" wrote:

=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