Hi Tomo.

Please supply a list of the rules to apply to each set of results.

"tomo" wrote:


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


--
tomo