Grade - One and Four Others

Giganews Newsgroups
Subject: Grade - One and Four Others
Posted by:  Salza (sal…@tm.net.my)
Date: Mon, 6 Oct 2003

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.

Replies