Request for a formula marks of my students
Solved/Closed
Related:
- Request for a formula marks of my students
- Student mark sheet grade formula in excel - Guide
- What do quotation marks mean in excel formula ✓ - Forum - Excel
- Student attendance sheet in excel with formula ✓ - Forum - Excel
- Student percentage formula in excel ✓ - Forum - Office Software
- Unable to complete request messenger ✓ - Forum - Facebook Messenger
2 replies
Hi Gouse,
In my country we don't work with grades, but I thought there are 6 grades (A-F).
I made them up like this:
80-100=A
60-79=B
50-59=C
40-49=D
30-39=E
0-29=F
I put a couple of marks in column A and put the following formula in B1 which I dragged down:
=IF(A1<=29,"F",IF(A1<=39,"E",IF(A1<=49,"D",IF(A1<=59,"C",IF(A1<=79,"B","A")))))
Change the formula (cell reference and condition) to suit your needs.
Best regards,
Trowa
In my country we don't work with grades, but I thought there are 6 grades (A-F).
I made them up like this:
80-100=A
60-79=B
50-59=C
40-49=D
30-39=E
0-29=F
I put a couple of marks in column A and put the following formula in B1 which I dragged down:
=IF(A1<=29,"F",IF(A1<=39,"E",IF(A1<=49,"D",IF(A1<=59,"C",IF(A1<=79,"B","A")))))
Change the formula (cell reference and condition) to suit your needs.
Best regards,
Trowa