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