software

Hi all...

I need help on a 'formula' for my students' marksheet.

For them to pass the whole exam, a student MUST PASS 7 SUBJECTS from 3
groups.

The grouping is like these :

A) Must pass ALL 4 subjects in Group A - marks are in cells D7, F7, H7, J7

B) Must pass AT LEAST 2 OUT OF 3 subjects in Group B - marks are in cells
L7, N7, P7

C) Must pass AT LEAST 1 OUT OF 2 subjects in Group C - marks are in cells
R7, T7Thank you so much

Hi Zainuddin,

It may not be the prettiest or most efficient way, i'm sure someone else
will post if there is a better way but i'd add one or more helper columns.

For example, say your pass mark is 70 but you could change this to whatever
you need.

In cell A7=if(D7 gt;= 70, 1, 0) if(F7 gt;= 70, 1, 0) if(H7 gt;= 70, 1, 0) if(J7 gt;=
70, 1, 0)
In cell B7 =if(L7 gt;= 70, 1, 0) if(N7 gt;= 70, 1, 0) if(P7 gt;= 70, 1, 0)
In cell C7 = if(R7 gt;= 70, 1, 0) if(T7 gt;= 70, 1, 0)
Then in cell D7 =if(A7= 4, 1, 0) if(B7gt;=2,1,0) if(C7gt;=1,1,0)
Then in cell E7 = if(D7=3, quot;Passquot;, quot;Failquot;)

You could amalgamate some of these together to make it 'prettier' but i hope
it helps.

Regards
Emma

quot;Zainuddin Zakariaquot; wrote:

gt; Hi all...
gt;
gt; I need help on a 'formula' for my students' marksheet.
gt;
gt; For them to pass the whole exam, a student MUST PASS 7 SUBJECTS from 3
gt; groups.
gt;
gt; The grouping is like these :
gt;
gt; A) Must pass ALL 4 subjects in Group A - marks are in cells D7, F7, H7, J7
gt;
gt; B) Must pass AT LEAST 2 OUT OF 3 subjects in Group B - marks are in cells
gt; L7, N7, P7
gt;
gt; C) Must pass AT LEAST 1 OUT OF 2 subjects in Group C - marks are in cells
gt; R7, T7
gt;
gt;
gt; Thank you so much
gt;
gt;
gt;
gt;