Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simplify formula | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |