Request for a formula marks of my students
Solved/Closed
Related:
- Request for a formula marks of my students
- Mark sheet grade formula in excel - How-To - Excel
- Find second position based on student marks ✓ - Forum - Office Software
- Unable to complete request messenger ✓ - Forum - Facebook Messenger
- You've requested too many codes facebook ✓ - Forum - Facebook
- You have requested too many sms codes please try again later - Forum - Facebook
2 replies
Trowa
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
