Howard

With column of scores in A enter this in B1 and double-click to copy down.

=LOOKUP(A1,{0,50,60,70,80},{"E","D","C","B","A"})

Adjust for score ranges or more letter grades like C+, B- etc.

=LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{"E","D"," C-","C","C+","B","B+","A"})

Adjust to suit.


Gord Dibben MS Excel MVP


On Fri, 29 Dec 2006 15:37:00 -0800, Howard
wrote:

ie if total is great than say 89 it will equal an A, or if greater than 83 it
will equal a B, or if greater than a 86 than it will equal a B+

Gord Dibben MS Excel MVP