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

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