|
|
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
|