I'm trying to figure out a formula to create a sliding scale. I've created an index and now I want to assign a fee based on the index.The fee should be a maximum of $1 for those with the highest index.For example,
Index Fee
A 118 ?
B 255 ?
C 215 ?
D 306 ?
E 479 $1.0
Any help is appreciated, thanks.