tiered commission

  1. B

    Calculating Commission Structure

    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+...
  2. E

    Calculating commissions with tiers, by month, AND across multiple people.

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

    Urgent Help! Calculating Tiered Commission...Please!

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

    Calculating Tiered Commission with an IF statement

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

Some videos you may like

This Week's Hot Topics

Top