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"})

Adjust the ranges and letters to suit.


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 11:21:08 -0800, JDenio
wrote:

i need a formula to place in my spreadsheet that provides the following:
If a number is or < a value, then place an alpha character in the cell.
I am a teacher and am trying to have the excel spreadsheet put the letter
grade in the cell where the total number of points earned is (because we
don't use the number of points, but letter grades).