request for a formula marks of my studentsSolved/Closed

Question

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?Configuration: Windows XP
Firefox 3.5.5

gouse · Accepted Answer

Hi, Trowa, Thanks for your kind reply. 
Fom : Gouse

Trowa · Answer

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

Request for a formula marks of my students

2 replies

Subscribe To Our Newsletter!