Commision calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top