Results 1 to 9 of 9

Formula calculate the comission according some condition

Threaded View

  1. #1
    Forum Contributor choy96's Avatar
    Join Date
    03-19-2010
    Location
    singapore
    MS-Off Ver
    Excel 2019
    Posts
    184

    Formula calculate the comission according some condition

    Formula calculate the comission according some condition

    example
    salesman achieve 4.5 box and 1 carton in a month.
    16box become 1 carton
    (4.5/16)+1 = 1.28 carton

    help me make a fromula can calculate as below:
    total carton 1.28, it on the range 1 box RM6 , 1 carton RM9.
    (box) 4.5 x 6 = 27
    (carton) 1 x 90 = 90

    total comission RM117

    Please refer to attachment, thks

    Reputation sure to be given for appreciate your helpful
    Attached Files Attached Files
    Last edited by choy96; 02-12-2023 at 08:48 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF formula to calculate bonus with multiple condition
    By hussainahmad in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-28-2018, 09:54 AM
  2. Tiered comission Formula
    By Pmanne1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2017, 10:45 AM
  3. How to get a formula to calculate only if a certain condition is met on another sheet
    By necht_angel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2012, 05:09 AM
  4. Comission Calculator Formula problem
    By leynadsvision in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-18-2008, 04:06 PM
  5. formula to calculate the average of a range basing on condition
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 07:05 AM
  6. formula to calculate the average of a range basing on condition
    By Krishna Mohan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. Calculate comission graduated scale, $2000=20%, $4000=40%, etc?
    By kalsolelady in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 06-21-2005, 06:05 AM

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