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