Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for commissions on a per piece bases
I am looking for a template or calcuation for piece work sales commission
payments. i.e. 1-100 gets paid at .10, 101-200 gets paid at .20 etc. so a person selling 150 would get paid 100 * .10 for 10 50 * .20 for 10 for a total of $20.00 drawing a formula blank at the moment. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for commissions on a per piece bases
If there are only two rates, then general formula would be:
=sales*rate1 +(sales-100)*(rate2-rate1) =150*0.1+(150-100)*(0.2 - 0.1) =15+5 If there is a range of rates look he http://www.mcgimpsey.com/excel/variablerate.html "LMM300M" wrote: I am looking for a template or calcuation for piece work sales commission payments. i.e. 1-100 gets paid at .10, 101-200 gets paid at .20 etc. so a person selling 150 would get paid 100 * .10 for 10 50 * .20 for 10 for a total of $20.00 drawing a formula blank at the moment. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Result required in 365-Days Bases | Excel Worksheet Functions | |||
pmt() uses 360-Days Bases, I need 365-Days Bases | Excel Worksheet Functions | |||
pmt() uses 360-Days Bases, I need 365-Days Bases | Excel Worksheet Functions | |||
Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
Need to "not show" piece of line in graph | Charts and Charting in Excel |