|Subject:||Grade - One and Four Others|
|Posted by:||Salza (sal…@tm.net.my)|
|Date:||Mon, 6 Oct 2003|
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.
I appreciate your time.