Request for a formula marks of my students

Solved/Closed
Report
-
 anonymous -
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?

2 replies

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

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

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