Results 1 to 2 of 2

Thread: Commission Structure Based on multiple sales packages and commissions

  1. #1
    Neophyte arkadd61's Avatar
    Join Date
    May 2013
    Excel Version
    Google Sheets

    Commission Structure Based on multiple sales packages and commissions

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm looking for assistance on another commission structure. Attached you will find an copy of the spreadsheet I'm working with. I have a reference chart for each of the potential package you could choose from in columns U - Z. As you look down this column you will see the various packages you can choose from.

    My goal is to have column "J" reflect the proper commission based on the package chosen in column "G", the threshold met in column "V" seen under each package.

    You can see the formula I started to build in column "J". But It's not getting me the proper result. The thresholds are not calculating correctly. In Row W2:Z2 is not calculating correctly. Example if you Enter "Copper Package" in "G2" and then put in the price point of $42.99 in "H2" the result should be $100.00 in "J2" as long as you are at 10 sales or less which is dictated by the reference in "R2".

    I hope this makes sense. Please let me know what else is needed. Any help would be appreciated!
    Attached Files Attached Files

  2. #2
    Admin Alumnus Pecoflyer's Avatar
    Join Date
    Oct 2011
    Brussels Belgium
    Excel Version
    2010 on Xubuntu

Posting Permissions

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