convert number score to letter grade

[fchoy]

How can I convert the number scores of my students into
letter grade? For example 91-100 is A, 81-90 is B, 71-80
is C etc. Thank you for your advice.

 

[Kevin Stecyk]

How can I convert the number scores of my students into
letter grade? For example 91-100 is A, 81-90 is B, 71-80
is C etc. Thank you for your advice.

Have a look at this thread. via Bob Umlas.

From: BobUmlas ()
Subject: Re: Vlookup also
View: Complete Thread (3 articles)
Original Format
Newsgroups: microsoft.public.excel.worksheetfunctions
Date: 1999/07/12


Set up the table like this (5 rows, 2 columns)
0 F
60 D
70 C
80 B
90 A
Name these 5r x 2c "Grades" (Not required, but good practice).
To find someone's grade using the value from column K, enter
=VLOOKUP(K2,Grades,2)
Where K2 is one of the grades. The 2 in the formula says to return the value
from the 2nd column of the table called "Grades".

http://www.google.com/groups?q=vloo...off=1&selm=OXMN5GNz#GA.52@cpmsnbbsa05&rnum=19

Regards,
Kevin

 

[Max]

In say, Sheet1, set-up a grade table in A2:B6
------------------
0 F
50 D
70 C
80 B
90 A

The above table presumes a slight tweak to the grade criteria, i.e.:

A: >=90
B: >=80 to <90
C: >=70 to <80
D: >=50 to <70
F: <50

In Sheet2, assume the marks are in col A, A2 down

 

[fchoy]

Hi Max:

Thanks for the fast response. Will try it out.

Francis

 

[Guest]

Hi Kelvin:

Thanks for the fast response. Will try it out.

Francis

 

[fchoy]

Hi Kevin:

Sorry I mispelled your name earlier. I tried you way and
it worked! Thanks again.

Regards

Francis

 

[fchoy]

Hi Max:

I tried your method and it worked!
Thanks very much again.

Regards

Francis

 

[Max]

Glad to hear that, Francis !
Thanks for the feedback

 

[Kevin Stecyk]

Hi Kevin:

Sorry I mispelled your name earlier. I tried you way and
it worked! Thanks again.

Regards

Francis

My pleasure, and thank you for reporting back to the group.

Regards,
Kevin