Newbie

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, 20 Jan 2005 11:49:11 -0800, Newbie
wrote:

Hi,

I have a several exam scores, eg 85%,75%,65% etc etc
I would like to know the easiest way of banding the scores such as 90% is
shown as A+, 80<90 is shown as A, 70<80 is B etc etc.

Grateful for any assistance.