Request for a formula marks of my students
Solved/Closed
Related:
- Request for a formula marks of my students
- Facebook review request - Guide
- Free fire submit a request - Guide
- Request a birthday change locked account - Guide
- Mark sheet grade formula in excel download - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
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
