Try something like this:

For a value in A1

B1: =VLOOKUP(A1,{0,1;21,2;51,3},2,1)&"A"
or
B1: =LOOKUP(A1,{0,21,51},{1,2,3})&"A"

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Lou" wrote:

Hi
I have a mixed column of numbers between 0 and 75. From these numbers I
want a second column to predict a future score. eg 0-20 would produce 1A,
20-50 would produce 2A and 50- 75 would produce 3A. Is it possible to do
with a formula please?

Thank you

Lou