1
$\begingroup$

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.

1 Answers 1