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.