Jazz M
New Member
- Joined
- Jun 8, 2018
- Messages
- 11
Hello all,
I am looking for some advice on how to set up a formula to allow me enter student marks for answering parts of a question
The question 3 parts (each part of the question has 5 marks each) and a student may answer any two parts. their marks are capped 10 marks so the maximum that can be earned is 10 marks
However I have come across students who have answered all 3 parts but I need a formula that only takes the best marks from 2 of the 3 parts only.
I was experimenting with MINA and subtracting in my formula but I got a bit confused, here is my formula
=SUM(A3:G3)-MINA(SUM(C3:E3),F3,G3)
here is what it looks like in Excel
<tbody>
</tbody>
I would be grateful for any help folks, thanks in advance
Jazz M
I am looking for some advice on how to set up a formula to allow me enter student marks for answering parts of a question
The question 3 parts (each part of the question has 5 marks each) and a student may answer any two parts. their marks are capped 10 marks so the maximum that can be earned is 10 marks
However I have come across students who have answered all 3 parts but I need a formula that only takes the best marks from 2 of the 3 parts only.
I was experimenting with MINA and subtracting in my formula but I got a bit confused, here is my formula
=SUM(A3:G3)-MINA(SUM(C3:E3),F3,G3)
here is what it looks like in Excel
Answer any 2 of 3 parts | |||||||
Q3 Part(A1) 3marks | Q3 Part(A2) 2marks | Q3 Part(B1) 3marks | Q3 Part(B2) 1mark | Q3 Part(B3) 1mark | Q3 Part(C1) 2marks | Q3 Part(C2) 3marks | Q3 Total Max 10 marks |
A3 | B3 | C3 | D3 | E3 | F3 | G3 | H3 |
<tbody>
</tbody>
I would be grateful for any help folks, thanks in advance
Jazz M