Advice - allocating points to value

[Mark0123]

Hi,

I have a list of scores in column A from 0-100 and am trying to allocate points depending on their scores in column B.

Criteria;
<50 = 100 points
51-80 = 200 points
81-100 = 300 points

I am able to do this a long way using look-ups but was wondering if anybody knows a tighter formula?

Thanks in advance

 

[gaz_chops]

Try

=LOOKUP(A1,{0,51,81,101},{100,200,300,0})

You don't say what if over 100?

 

[pgc01]

Hi Mark

Tighter than with Lookup()?

I don't see how.

This is the lookup I'd use, similar to gaz_chops's:

=LOOKUP(A1,{0,100;51,200;81,300})

 

[gaz_chops]

Hi Mark

Tighter than with Lookup()?

I don't see how.

This is the lookup I'd use, similar to gaz_chops's:

=LOOKUP(A1,{0,100;51,200;81,300})

Even neater, I always forget that option!