Gord,
I've converted it to fit my needs but am getting an error. Here is my
formula what am i doing wrong?.
=LOOKUP(L15,{
0,49,50,53,54,56,57,59,60,63,64,66,67,69,70,73,74, 76,77,79},{"F","D-",D,D+,"C-","C","C+",B-,"B","B+",A-,A,"A+"})
--
A.
"Gord Dibben" wrote:
To convert scores to letter grades use a Lookup table and VLOOKUP functions.
OR a Lookup formula without a table
Assuming scores are in column A starting at A1.
In B1 enter this formula then drag/copy down column B
=LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{"E","D"," C-","C","C+","B","B+","A"})
Example only. Adapt for your scores and grades.
Note the curly braces internally.
Or see Chip Pearson's site for yet another take on a combination of the two
methods above.
http://www.cpearson.com/excel/excelF.htm#Grades
Gord Dibben MS Excel MVP
On Tue, 5 Dec 2006 13:59:01 -0800, Andmor
wrote:
I"ve collected all the marks for some 400 students and wished to convert them
from percentials into letter grades. Here is the breakdown for the letter
grades:
90 A+
85 - 89 A
80 - 84 A-
77 - 79 B+
74 - 76 B
70 - 73 B-
etc...
Now i have my percentages starting in L6 and would like to have the letter
grades starting @ M6.
I was thinking a nested if statement? please help!
Gord Dibben MS Excel MVP