Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multiply ranges within a value by differing amounts
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Multiply ranges within a value by differing amounts
Resolved · High Priority · Version 2007
Reply Thu 17 Mar 2011, 18:52Delegate James said...
James has attended:
No courses
Multiply ranges within a value by differing amounts
I need a function formula that works out tiered commission. What I mean is, add together 10% of 0-100, 13% of 100-200, 16% of 200-300, 19% of 300-400, 21% of 400-500 & 24% of 500+
So, if I enter 200, I get 23. (10% of 0-100+13% of 100-200)
if I enter 456, I get 69.76 (10+13+16+19+11.76) (11.76 being 21% of 56).
Thanks. Hope you can help.
James.
For upcoming training course dates see: Pricing & availability
RE: multiply ranges within a value by differing amounts
Hello James,
Thank you for your question regarding a tiered commission formula. I have created a small spreadsheet with a commission table. I have created a formula with nested IF statements which calculate the outcomes you requested.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Attached files...
commission structure.xlsSun 27 Mar 2011: Automatically marked as resolved.
|