Ranking data ranges 1-10

  • Thread starter Thread starter victorcab
  • Start date Start date
V

victorcab

I have a formula I am trying to create that will rank numeric data fro
1-10.

I have tried this nested formula and it doesn't really work too well a
it is limited in ranges.
=IF(R20>600,"1"
IF(R20>400,"2",IF(R20>300,"3",IF(R20>200,"4",IF(R20>100,"5",IF(R20>75,"6",IF(R20>50,"7","8")))))))

If I try to add one more condition it doesn't accept it.

I would like to create something where I can say
range 1-15 = 1
range 16-25 = 2
etc

Any thoughts/advice would be greatly appreciated.

Thanks,
Victo
 
The RANK function may be a good solution. Not really enough detail t
give you a specific example...

Some general advice you could total the ranges and then rank th
ranges..
 
Maybe this will help clarify a little. sorry for the confusion.

I have variable data in one cell and I want to assign a value of 1-1
based on the data in the calculation cell.

example:
data cell calculation cell based on formula
700 =8
500 =6
.....

I would change the ranges based on data sample, but this would b
manual.

It's kind of hard to explain, but if there was a way for me to get mor
ranges out of the formula above that would solve my problem.

Thank you
 
Something like:

=LOOKUP(R20,{0,0;1,1;16,2;...})

where you need to fill in the ... bit.

BTW, the formula you tried uses a different set of values than the last bit
of your post. However, the logic of setting up the {...} bit in the LOOKUP
formula would be identical.
 
Back
Top