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