Commision calculation

[Guest]

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.

 

[Guest]

=LOOKUP(A1,{0,7.5,15},{5%,8%,12%})*A1

 

[Don Guillett]

On all or on the tiers?

 

[Guest]

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