tiered commission

Hello! I'm having trouble creating a spreadsheet that will calculate correctly. Our commission structure is set up as follows: We take 10% of the total commission received per sale (our "FF"), 90% goes back to the employee. However, once the employee has contributed $15k, our FF goes down to...

Hello I am trying to create an excel table to calculate a commission structure. Here is the structure that I am working with: <colgroup><col span="3"><col></colgroup><tbody> £0k to £9k 0% £0.00 £9k - £29999 10% £2,100.00 £30k - £44999 15% £2,250.00 £45k - £59999 20% £3,000.00 £60k+...

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...

Hi all 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 (so...

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <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> <o:p>...