Request for a formula marks of my students
Solved/Closed
Hello,
sir, I am a teacher. I entered marks of my students in a column in excel-2007 work sheet. I have to prepare grades from the marks. Marks from 80 to 100 is "A" grade. 60 to 79 is "B" grade. 50 to 59 is "C" grade and so on. How do I enter a formula to prepare grades?
sir, I am a teacher. I entered marks of my students in a column in excel-2007 work sheet. I have to prepare grades from the marks. Marks from 80 to 100 is "A" grade. 60 to 79 is "B" grade. 50 to 59 is "C" grade and so on. How do I enter a formula to prepare grades?
Related:
- Request for a formula marks of my students
- Microsoft access free download for students - Download - Databases
- Submit a request free fire - Guide
- Message request on instagram disappeared - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Free fire account transfer request - Guide
2 responses
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