If Statement to return Fail Pass Merit or Distinction.

Hi,

I have attached an image to help explain.
What I want is if all "Pass" cells have a Y or Y* in then the grade displays "Pass" if not to display "Fail". If the Merit cells contain Y or Y* the grade needs to display "Merit" and the same for Distinction.

However if all merit and distinction are Y or Y* but there is one missing from the Pass the grade needs to say "Fail".

I hope I have explained it well enough to understand and would appreciate any help.

Formula i have at the moment to just display pass:
=IF((AND(OR(C10="Y*",C10="Y"),OR(D10="Y*",D10="Y"),OR(E10="Y*",E10="Y"),OR(F10="Y*",F10="Y"),OR(G10="Y*",G10="Y"),OR(H10="Y*",H10="Y"),OR(I10="Y*",I10="Y"),OR(J10="Y*",J10="Y"))),"PASS","FAIL")

Thank you for your quick reply.

Sorry i forgot to mention, all the merits need to be Y or Y* to be return a merit and the same with distinctions. i presume i just have to change the >0 to 6 and 4 respectively.

I have just tried the forumla with the pass criteria and its just returning TRUE whether there are 7 Ys or 8.

also can you explain how "*Y*" means Y or Y*.

Thanks

Thanks for that, it works quite well but not 100% correct. Is there a way to make it so if there is 1 merit missing the grade will be a pass. Even if all the distinctions have been met and 1 merit is missing the overall grade will still be a pass.

sorry to be a pain.

SUPER!! thats perfect, Thank you for you help.