assigning ranks to number ranges

[Guest]

Hi,
Just wondering if anyone could tell me what formula I would need to use in
this instance:
If the value in one cell falls between a certain range (i.e 12-30), I would
like to transfer it to a number ranking (i.e 1) in the cell below.
Basically, what I am trying to do is turn ranges of scores into their
respective STEN scores.

Thanks in advance,
Nikki

 

[Aladin Akyurek]

Construct a table like:

0,0
12,1
31,2
etc.,

then invoke:

=LOOKUP(Value,Table)