Results 1 to 21 of 21

Sumproduct Tiered Commission Payment

Threaded View

  1. 04-05-2018, 03:13 AM #1
    jjk984
    jjk984 is offline
    Registered User
    Join Date
    04-05-2018
    Location
    South Africa
    MS-Off Ver
    10
    Posts
    6

    Unhappy Sumproduct Tiered Commission Payment

    Hi,

    I have used sumproduct formula to calculate tiered commission payments and all works correctly, except if you exceed the threshold on the first deal.
    Assuming the threshold is 1,050,000 at 70% and your first deal is 2,000,000 then the payment should be 1,400,000, however the sumproduct formula applied calculates 1,205,000. Can't figure out why?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Tiered commission pay
    By BlueStreamCS in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-03-2018, 11:46 AM
  2. [SOLVED] Tiered commission formula past 6
    By trosasco23 in forum Excel General
    Replies: 1
    Last Post: 09-29-2014, 08:26 AM
  3. Tiered Commission Structure
    By emily.kell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2014, 10:59 PM
  4. Need help with a tiered commission calculator
    By bmc1492 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-06-2014, 10:46 AM
  5. Tiered Commission Calculation
    By Rushmore in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2012, 12:18 AM
  6. Tiered Commission
    By rock_chalk35 in forum Excel General
    Replies: 7
    Last Post: 06-08-2012, 01:39 PM

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