Commission formula
Trying to build a formula for a tiered commission plan so that the sales person can calculate commissions based on the number of accounts and dollar volume of each account on a monthly/yearly basis. The commission structu 7.5% of the first 0-$5,000 of sales each month 12.5% of the next $5,000-10,000 each month 15% of $10,001 + The salesperson should see the commission earned at each tier after inserting the variable numbers. I know this is pretty basic, but I need the help. Thanks. -- jaywerth ------------------------------------------------------------------------ jaywerth's Profile: http://www.excelforum.com/member.php...o&userid=28336 View this thread: http://www.excelforum.com/showthread...hreadid=479145 |
Commission formula
Example here
http://www.mcgimpsey.com/excel/variablerate.html -- Regards, Peo Sjoblom "jaywerth" wrote in message ... Trying to build a formula for a tiered commission plan so that the sales person can calculate commissions based on the number of accounts and dollar volume of each account on a monthly/yearly basis. The commission structu 7.5% of the first 0-$5,000 of sales each month 12.5% of the next $5,000-10,000 each month 15% of $10,001 + The salesperson should see the commission earned at each tier after inserting the variable numbers. I know this is pretty basic, but I need the help. Thanks. -- jaywerth ------------------------------------------------------------------------ jaywerth's Profile: http://www.excelforum.com/member.php...o&userid=28336 View this thread: http://www.excelforum.com/showthread...hreadid=479145 |
All times are GMT +1. The time now is 08:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com