+ Reply to Thread
Results 1 to 2 of 2

Urgent Help required with Formulas for Calculating Commission

  1. #1
    Registered User
    Join Date
    01-09-2013
    Location
    Bracknell, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Urgent Help required with Formulas for Calculating Commission

    I am trying to find the right formulas to use for calculating commission for the following;

    1. Target 1 – for the year is £486,000 GP. Any sales up to this target will be paid standard commission rates up to 100%.
    2. Target 2 – If within a quarter period you exceed the target but are under the budget then the commission between those two figures will have an automatic accelerator of x1.5. The budget is £648,000 GP for the year.
    3. Target 3 – If within a quarter period you exceed the budget then the commission over that budget figure will have an automatic accelerator of x2.

    I have a commission calulation sheet set up from last year but there has been some changes for this fiscal year and I thought i could use the same excel sheet and amend the forumlas but seem to be having a bit of trouble and not sure if i should just start a fresh.

    I have attached the current excel sheet so you can see the existing formulas.

    A help would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    04-23-2013
    Location
    Abu Dhabi United Arab Emirates
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Urgent Help required with Formulas for Calculating Commission

    can you put some desired result to your uploaded file

+ 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