I am trying to work out a fomular for calculating college grades, i have found the formular for if all grades are the same as in the 1st line below.

trying to get formular for the examples in 2 to 4 which are causing problems. any ideas?

A B C D E

1 P P P P = Pass =IF(AND(A10="p",B10="p",C10="p"),"Pass")

2 P M M M = Pass

3 D M P M = Pass

4 M D D M = Merit

greatful for this formular

tomo