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