I'm trying to set up a calculator for the following information.

Range Percent Per Point
1-100 = 0.10
101-500 = 0.025
501-1000 = 0.02
1001-8000 = 0.01

The calculator should allow the user to enter a number within the range and then calculate a total percentage based on the percent per points.

ex. user enters 600
100 points * .10 = 10%
399 points * 0.25 = 9.975%
101 points * 0.02 = 2.02%
for a combined total of 21.995%

The calculator would then display 21.995% in a cell next to where the user entered 600. Please post the equation. Thank you in advance.

-Kevin.