Microsoft EXCEL 2000 Formula
I am sorry, I don't understand how this relates to what you first asked.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Lou" wrote in message
...
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
|