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

 

[JBeaucaire]

To do 50, I would create a chart somewhere. The chart should be i
ascending numerical order, and it only needs to indicate the beginnin
of each range. When you enter the beginning of the next range, tha
implicitly sets the cap for the prior range. The chart lists th
beginning number of each "range" in first column, and the second colum
the results for that range

Based on what you said so far, the table would look like this

Code
-------------------
Column X Column
1 0
2 100
3 200
4 300
5 400
6 500
7 600
-------------------


Once your chart is complete, go back to your data set and in I1 ente
this formula to compare H1 to this chart

=VLOOKUP(H1,$X$1:$Y$7,2,TRUE

Of course, if your chart is bigger, adjust those chart references. No
copy it down to get your "results"

 

[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).