Hi Ron

Thanks for trying to help me. I am afraid I am not too skilled in excel. I
have only used Sum and Average before. I have tried using the formulas but
instead of producing a result of 1A, 2A or 3A as appropriate in cell B2 it
simply pastes the whole formula into cell B2. Its probably me Ahhh!!!!

Lou

"Ron Coderre" wrote:

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