And yet another.........

=LOOKUP(A1,{0,51,70,86},{"D","C","B","A"})

Note the curly braces internally.

Gord Dibben Excel MVP


On Sat, 13 Nov 2004 17:43:30 -0600, Aladin Akyurek
wrote:


If values as 69.4 and 69.7 are not possible...

=LOOKUP(A1,{0,"D";51,"C";70,"B";86,"A"})

lawrend Wrote:
I am trying to write a formulae that returns an A, B, C or D depending
on
percentage scored in a test.
i.e i will have students who do a test, then receive a percentage mark
out
of 100.
Then i would like to convert that to a grade as below.

Say 0 - 50 = D
51 - 69 = C
70 - 85 = B
86 - 100 = A

Can anyone help please. I have succeded in doing this in a lookup table
but
I would like to be able to write this in a single cell as a formulae. I
have
tried doing it with an IF statement but can't seem to get my head
around it.

Thanks in advance ....