Assuming your names are in column A and your scores are in column B in C1
put GRADES
in G1 put 0
in G2 put 50
in G3 put 65
in G4 put 80
in G5 put 95
and
in H1 put F
in H2 put D
in H3 put C
in H4 put B
in H5 put A
finally in C2 put this formula and copy down..........
=VLOOKUP(B2,$G$1:$H$5,2,TRUE)
Vaya con Dios,
Chuck, CABGx3
"donfettuccini"
wrote in message
news:donfettuccini.1s2x6t_1121209548.6375@excelfor um-nospam.com...
Hello!
I have a list of 100 names and test scores, then a range of letter
grades.
Name Scores
Joe 100
Billy 95
Max 65
John 49
Grades from100-95, will get a letter Grade A
Grades from 94-80, will get a letter Grade B
79-65, will get a letter Grade C
64-50, will get a letter Grade D
49-0, will get a letter Grade F
I wanted to know if there is a combination of function that will allow
me to convert the scores to their corresponding letter grade. Possible
without macros.
Thanks
--
donfettuccini
------------------------------------------------------------------------
donfettuccini's Profile:
http://www.excelforum.com/member.php...o&userid=25168
View this thread: http://www.excelforum.com/showthread...hreadid=386634