+ Reply to Thread
Results 1 to 3 of 3

bonus commission for every 10 sales

  1. #1
    Forum Contributor
    Join Date
    04-01-2015
    Location
    Sydney Australia
    MS-Off Ver
    Office 365 latest
    Posts
    171

    bonus commission for every 10 sales

    Hello,
    here I have commission at 20% for total sales in column F.
    and a bonus commission for every 10 sales accumulated in column G. (at 10% of total dollar value earned in column E).

    how do I make column G automatically do this calculation based on changing values in column B and D. (total sales x product value).
    (For every 10 sales, they get 10% of adjusted value in E).

    for example product value $5000, x 10 sales = $50,000, bonus commission is $5,000 (10%).
    if 20 sales, thats 100K revenue, bonus commission is $10,000
    if 30 sales, thats 150K, bonus commission is $15,000


    bonus commission2.JPG
    Last edited by jitterbug888; 06-07-2019 at 10:23 PM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: bonus commission for every 10 sales

    Maybe
    G3
    =D3*INT(B3/10)*10*10%
    or
    =D3*INT(B3/10)

  3. #3
    Forum Contributor
    Join Date
    04-01-2015
    Location
    Sydney Australia
    MS-Off Ver
    Office 365 latest
    Posts
    171

    Re: bonus commission for every 10 sales

    Awesome thankyou !!. Bo_ry

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to calculate tiered commission/bonus
    By shrijan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-27-2017, 08:44 AM
  2. Replies: 2
    Last Post: 03-21-2017, 04:17 PM
  3. Formula for Staff Bonus / Commission
    By drdevin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2015, 01:41 PM
  4. Help! Tiered sales/bonus structure...
    By cubby777 in forum Excel General
    Replies: 1
    Last Post: 03-29-2014, 06:21 AM
  5. [SOLVED] Formula help - finding 1/4 sales amount and then the appropriate bonus
    By invgrp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2013, 12:21 AM
  6. Calculating a Sales Bonus When the Bonus Rate Changes as Sales Change
    By daydreamz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2012, 11:52 AM
  7. Excel 2007 : Sales Commission
    By jolynn121 in forum Excel General
    Replies: 2
    Last Post: 03-06-2011, 02:31 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