An in-line array, gets useful for multi-condition tests.

You would only change one, then copy down for the rest. Not arguing against
a table, just pointing out that it is not that onerous. More importantly, if
there are many instances of that type formula (the non-table type), it is
less efficient and consumes more workbook.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stevie_mac" wrote in message
...
That's a good tip Bob, I didn't even realise you could list in-place (so
to speak).
I'll have to remember that one!

NOTE to Andy, If you change your points scoring system, then you have to
change every instance of this, If you use a
table (as in the answer I submitted) then you only change the points in
the table once.

"Bob Phillips" wrote in message
...
=LOOKUP(A1,{0,5;70,15;80,14;85,14;90,13;95,12;100, 10;101,8;110,7;120,5})

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andy" wrote in message
...
Hi All,

I need some help with mulitple condtion using if and else if(If
possible)
otherwise I am open for better ideas.
I have 2 columns A & B (These number are just estimated points it will
be
changed)
Column A Column B
< 70 5 Points
70-80 15 Points
80-85 14 Points
85-90 13 Points
90-95 12 Points
95-100 12 Points
100 10 Points
100-110 8 Points
110-120 7 Points
120 5 Points
Based on Column A, I want the formula in Column B to generate the
points.
I hope I am not asking that cannot be done :-)
Please if someone can help.

Thanks in Advance
AM