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.

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.

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.

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.