Results 1 to 4 of 4

Tiered commission or fee structure

Threaded View

  1. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Tiered commission or fee structure

    See the sheet.

    1. You need to add a new column showing the % difference between tiers.

    2. Forumula: =SUMPRODUCT(--(D10>$A$2:$A$5),--(D10-$A$2:$A$5),$D$2:$D$5)

    3. Your expected answer was MILES out!!
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Tiered Commission Structure Depending on Type of Transaction
    By QuentinL in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-04-2020, 04:00 AM
  2. Tiered commission structure formula
    By bwhite107 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-29-2018, 02:15 PM
  3. Formula(s) needed for Tiered Commission structure
    By Charly6s in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2016, 09:53 PM
  4. Circular Reference, for tiered commission structure
    By cgately in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-02-2015, 08:01 PM
  5. Tiered Commission Structure
    By emily.kell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2014, 10:59 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1