Bob

Thanks for this. Is it possible to extend it further? As a second formula,
it would be good if I could show other levels too. i.e. up to and including
29 would give a W in column B, 30 -37 would give a 1, 38-44 would give a 2C,
45 -55 would give a 2B 56-65 would give a 2A and over 66 would give a 3.

I have been trying to adapt the first one you gave me with little success.
Any help would be greatly appreciated. Thanks again.

Lou



"Bob Phillips" wrote:

=(A10)+(A120)+(A150)&"A"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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