In your IF formula, you are probably testing the values from bottom to top
instead of top to bottom.

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

PS: IMO a lookup formula is more efficient. If you later change the cutoff
points, you need only to change the data in the table.


On Sat, 13 Nov 2004 23:14:18 +0000 (UTC), "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 ....