Closed Thread
Results 1 to 3 of 3

Commission calculation

  1. 01-09-2010, 05:50 AM #1
    sadi
    sadi is offline
    Registered User
    Join Date
    01-09-2010
    Location
    Bangladesh
    MS-Off Ver
    Excel 2003
    Posts
    2

    Commission calculation

    Hi all, hope you can help.
    I am creating an commission datasheet for my sales team to calculate commission. However the formula is beyond my abilities.
    We have two figures. Total sales (A) and % of commission against sales (B). The way it is calculated is as follows.
    If A is 1 To 9.99 Commission 1.2% on A
    If A is 10 To 19.99 Commission 1.3% on A
    If A is 20 To 29.99 Commission 1.4% on A
    If A is 30 To 39.99 Commission 1.5% on A
    If A is 40 To 49.99 Commission 1.6% on A
    If A is 50 To 59.99 Commission 1.7% on A
    If A is 60 To 79.99Commission 1.8% on A
    If A is 80 To 99.99 Commission 1.9% on A
    If A is 100 To 149.99 Commission 1.95% on A
    If A is >150 Commission 2% on A

    It will calculate up to 500 rows

    How can i Calculate. SOMEONE HELP ME PLEASE...

    sadi
    Reply With QuoteRegister To Reply
  2. 01-09-2010, 06:00 AM #2
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Commission calculation

    If we assume the commission is not tiered - the simplest thing to do is create a table like so:

    Please Login or Register  to view this content.
    If assume above is located in Columns E:F then

    Please Login or Register  to view this content.
    where A1 holds Sales

    revise ranges as necessary.
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With QuoteRegister To Reply
  3. 01-10-2010, 05:19 AM #3
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Commission calculation

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    Given responses elsewhere - thread closed to prevent members wasting their time.
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1