Calculate Sliding Scale Calculation
I need to be able to calculate a commission as follows:
Total Amount=$500 Total Commission (0-$100, 5%)+($101-399, 10%)+($400, 15%) This would calculate a different percentage for each of the ranges above and then add them together. I hope I'm making myself clear because I'm confused just writing this. It seems like there should be a very easy way to do this in Excel. Any assistance would be most appreciated. Thanks, Andy |
Calculate Sliding Scale Calculation
See
http://www.mcgimpsey.com/excel/variablerate.html In article .com, "Andy" wrote: I need to be able to calculate a commission as follows: Total Amount=$500 Total Commission (0-$100, 5%)+($101-399, 10%)+($400, 15%) This would calculate a different percentage for each of the ranges above and then add them together. I hope I'm making myself clear because I'm confused just writing this. It seems like there should be a very easy way to do this in Excel. Any assistance would be most appreciated. Thanks, Andy |
All times are GMT +1. The time now is 08:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com