It's been a loooong time since I was in a math class and can't remember how to do this.

I need formula to reduce a range of values to a scale of 1 to 100.
For example my highest value is 900 and the lowest is 27.
So 900 would become 100 and 27 would become 1.
The numbers in between will be converted to a number between 1 and 100.

Oh, and this needs to work with fractions and negative numbers.
For example a possible range could be 0.53 to -0.67.

I'm doing this in VB6