One way:

=IF(A1<51,"D",IF(A1<70,"C",IF(A1<86,"B",IF(A1<101, "A","error"))))

This tests the value in cell A1 and returns a grade from D to A. If a
student scores more than 100, it is marked as an error ... though you don't
need this test.

Regards

Trevor


"lawrend" wrote in message
...
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 ....