Results 1 to 10 of 10

Multi Tiered Commission Function

Threaded View

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    florida
    MS-Off Ver
    2013
    Posts
    19

    Multi Tiered Commission Function

    Good Morning,

    I have been working on trying to create a multi tiered commission table and I am having no luck writing the function. The commission breaks are 0-9 no commission, 10-19 is times 10 of the total appointments from 10-19, 20-29 is times 20 of the total appointments from 20-29, and the final is 30-higher is 30 times the total number appointments after 30. So if the person set 31 appointments they would get $360. If the person set 22 they would get $140.

    Thanks
    Brett
    Attached Files Attached Files
    Last edited by bbeards2; 09-24-2014 at 10:00 AM.

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
    By emily.kell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2014, 10:59 PM
  2. Need help with a tiered commission calculator
    By bmc1492 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-06-2014, 10:46 AM
  3. Tiered Commission Calculation
    By Rushmore in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2012, 12:18 AM
  4. Tiered Commission
    By rock_chalk35 in forum Excel General
    Replies: 7
    Last Post: 06-08-2012, 01:39 PM
  5. Tiered Pricing Commission Calculation
    By kludge in forum Excel General
    Replies: 2
    Last Post: 04-13-2011, 06:10 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