Number rating

[chinley]

Hi,

I have been given a list of 10,000 numbers (non-sequential) ranging from 100 to 3000 and have been asked to "rate" them. I need a formula that rates each number from 1 to 10, ie 100 will eqaul a rating of 1 and 3000 = 10.

Any help would be much appreciated!

 

[shg]

Try

=INT(10*(A1-100)/2901) + 1

 

[chinley]

Thanks a lot

 

[shg]

You're welcome.