Hello,

Try this formula:

=IF(AND(E7<"E";COUNTIF(G7:AC7;"E")<9);"PASS";"FAI L")

This should work, if you don't have data in those cells
F7, H7, J7, etc. (or the cell value in any of those cells
is not letter E).

Ecco

-----Original Message-----
Hi all,

I am preparing an exam marksheet.

I have 13 columns for grade .... which are E7, G7, I7,
K7, M7, O7, Q7, S7,
U7, W7, Y7, AA7, AC7
The five grades are A,B,C,D and E.
Grade E is a fail.
Column AE7 shows the overall result ... PASS or FAIL.

For a student to pass the whole exam (marked as PASS in
Column AE7), he must
pass a subject in E7 (get at least a D) AND he must also
pass any FOUR other
subject in column G7 to AC7.

I tried a few formula but don't seem to work.

Please help me with a correct formula.

Thanks.
I appreciate your time.


.