Hello I am trying to create an excel table to calculate a commission structure.
Here is the structure that I am working with:
£0k to £9k
£9k - £29999
£30k - £44999
£45k - £59999
My question is related to calculating sales commissions.
Here's my problem: determining a commission rate is based on what has been closed in a territory, but calculating the actual commission earned is based off what a person himself closed. I know how to do this with a ton of nested if...
I am trying to work out a formula for my below commission structure;
£0.00 - £5,000 generated = 0% commission
£5,000 - £10,000 = 15% commission
£10,000 - £15,000 = 17.5% commission
£15,000 - £20,000 = 20% commission
£20,000 - £25,000 = 22.5% commission
£25,000 + = 25% commission
Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
I need a formula to help calculate the commission for my team at work. We are collectors and take credit card payments to clear up delinquency. Here is how the tiers work:<o:p></o:p>