Hi
put your lookup table in a separate table (e.g. called lookup):
- in column A enter ONLY the lower boundary (e.g. 0 in A1, 51 in A2,
etc.)
- in column B enter the letter

Now use the following formula on your other sheet (where A1 contains
the lookup value):
=VLOOKUP(A1,'lookup'!A1:B10,2,TRUE)


--
Regards
Frank Kabel
Frankfurt, Germany


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 ....