| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Commision calculation
I'm using Excel 2003 and am trying to calculate commissions. My spreadsheet
is as follows: A B C D E 2006 1st Qtr. 2007 1st Qtr Difference % growth 1st Qtr. Commision The commission scale is as follows: Growth from 0% to 7.499% will be paid at 5% Growth from 7.5% to 14.99% will be paid at 8% Growth above 15% will be paid at 12% If you need more information, please let me know. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Commision calculation
=LOOKUP(A1,{0,7.5,15},{5%,8%,12%})*A1
"sylvia" wrote: I'm using Excel 2003 and am trying to calculate commissions. My spreadsheet is as follows: A B C D E 2006 1st Qtr. 2007 1st Qtr Difference % growth 1st Qtr. Commision The commission scale is as follows: Growth from 0% to 7.499% will be paid at 5% Growth from 7.5% to 14.99% will be paid at 8% Growth above 15% will be paid at 12% If you need more information, please let me know. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Commision calculation
On all or on the tiers? -- Don Guillett SalesAid Software "sylvia" wrote in message ... I'm using Excel 2003 and am trying to calculate commissions. My spreadsheet is as follows: A B C D E 2006 1st Qtr. 2007 1st Qtr Difference % growth 1st Qtr. Commision The commission scale is as follows: Growth from 0% to 7.499% will be paid at 5% Growth from 7.5% to 14.99% will be paid at 8% Growth above 15% will be paid at 12% If you need more information, please let me know. Thanks in advance. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Commision calculation
I'm sorry that was so jumbled up, let me try and do it again.
Column A is 2006 1st Qtr. sales Column B is 2007 1st Qtr. sales Column C is the difference between 2006 and 2007 1st Qtr sales Column D is the percent growth between the two quarters Thank you "Don Guillett" wrote: On all or on the tiers? -- Don Guillett SalesAid Software "sylvia" wrote in message ... I'm using Excel 2003 and am trying to calculate commissions. My spreadsheet is as follows: A B C D E 2006 1st Qtr. 2007 1st Qtr Difference % growth 1st Qtr. Commision The commission scale is as follows: Growth from 0% to 7.499% will be paid at 5% Growth from 7.5% to 14.99% will be paid at 8% Growth above 15% will be paid at 12% If you need more information, please let me know. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating commision on sales | New Users to Excel | |||
| I'm looking for a tiered sales commision tracker | Excel Discussion (Misc queries) | |||
| Calculating sales commision HELP!!!!!!! | Excel Worksheet Functions | |||
| salary, hourly wage plus commision | Charts and Charting in Excel | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Linear Mode
