Help with function / Formula

[Jerry Bailey]

601
600
595
550
525
505
500
450
400
350
300

Using the above example in an adjacent column I would like to assign the
number 1 for all cells = to or greater than 600 , the number 2 to all cells
less than 599 but greater than 500, the number 3 to all cells less than 499
but greater than 400, and so on. I realize the if function may work however
I am using excel 2003 and I believe the limitation is approx 7. I need a
formula that will allow up to approx 50 different nemerical associations
Thanx

 

[Rick Rothstein]

If there is any kind of regularity in the difference of your ranges (as you
show in your example), then there may be a direct mathematical solution. If
you tell us how the ranges progress, then we could determine if such a
mathematical formula exists or not.

 

[Dana DeLouis]

Assuming the same relationship, this might work, but you will have to
adjust for your valid range.

=7-INT(A1/100)

Dana DeLouis

 

[Rick Rothstein]

I'm pretty sure that won't handle the OP's 50 different numerical
associations<g>. We need more information from the OP before a mathematical
solution can be suggested (hence, my posting elsewhere in this thread).