=(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