Threshold Equation Help
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. |
All times are GMT +1. The time now is 02:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com