A
Andy
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
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