Request for a formula marks of my students

Solved/Closed
gouse - Jan 21, 2010 at 09:08 AM
 anonymous - Jun 23, 2013 at 12:48 AM
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?
Related:

2 responses

Hi, Trowa, Thanks for your kind reply.
Fom : Gouse
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
thank you very much. . .i've made my excel project perfectly
0