+ Reply to Thread
Results 1 to 3 of 3

Calculating Accumulative Commission

  1. #1
    Registered User
    Join Date
    08-08-2007
    Posts
    1

    Calculating Accumulative Commission

    having a problem with the forumula's in setting up a commission calculator

    that calculates accumulative commision

    the structures are as follows:
    • Sales from Band 1: £0 to £4999 = zero % commission
    • Sales from Band 2: £5000 to £8000 = 10% commission
    • Sales from Band 3: £8001 to £12000 = 15% commission
    • Sales from Band 4: £12001 to £15000 = 20% commission
    • Sales from Band 5: £15001 to £25000 = 25% commission
    • Sales from Band 6: £25001 and above = 30% commission
    an example of the payment are as follows:
    • £6,000 = £ 100
    • £8,000 = £ 300
    • £10,000 = £ 600
    • £12,000 = £ 900
    • £15,000 = £1,500
    • £18,000 = £2,250
    • £20,000 = £2,750
    • £28,000 = £4,900


    Thanks

    Outspokensa

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Hello outspokensa,

    Take a look at this link on commissions, it may help

    http://www.mcgimpsey.com/excel/variablerate.html
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    04-05-2007
    Location
    Sydney Australia
    Posts
    48
    Hi Outspokensa

    The attached file should do what you need. I'm sure there are better ways to do it but it works for me. Adjust cell references to suit your situation.

    Jeff
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1