+ Reply to Thread
Results 1 to 5 of 5

Commission Structure Based on multiple sales packages and commissions

  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    Orem, UT
    MS-Off Ver
    Excel 2010
    Posts
    58

    Commission Structure Based on multiple sales packages and commissions

    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, + the "Package Bump" as seen in column "U".

    I hope this makes sense. Please let me know what else is needed.

    SafestHome Spreadsheet-2.xlsx

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Commission Structure Based on multiple sales packages and commissions

    See attached file.Below formula is used.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-02-2013
    Location
    Orem, UT
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Commission Structure Based on multiple sales packages and commissions

    kvsrinivasamurthy:

    Thank you for your reply. Your formula is working great except for the last section MATCH( 'Safest Home' !H2, $W$2:$Z$2, 1)),""). This section of the formula only references the "Copper Package" on the pricing chart. Is there a way to adjust the formula to reflect the pricing for each package as each package has different price points. Example "Bronze Package" W8:Z8 is $35.99, $41.99, $43.99,$47.99 & "Silver Package" W14:Z14 is $37.99, $43.99, $45.99, $49.99 etc...

    Thank you very much for your assistance!

    Semisi

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Commission Structure Based on multiple sales packages and commissions

    Sorry.Now I have changed formula.
    Array formula is used.See the attached file.
    Attached Files Attached Files

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Commission Structure Based on multiple sales packages and commissions


+ 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