Excellent solution to find the commission with the various levels grouped
together. However, I need to see each commission broken out at each level.
For example, if the sales is $60K, I need the breakdown for commission for
the first $15K at 25%, then commission for $15k-$30K at 30%, commission for
$30K-$50K at 35%, commission for $50K-$80K at 40%, then portion over $80K at
45%. Are you able to "ungroup or un-nest" the solution so that they apply
only per commission band?

"Peo Sjoblom" wrote:

Take a look here


http://www.mcgimpsey.com/excel/variablerate.html

--
Regards,

Peo Sjoblom


"Dixie" wrote in message
...
I am trying to nest 3 conditions for a commission pay structu
$0-$15,000
= 25%; $15,000-$30,000 = 30%; $30,000-$50,000 = 35%. D6 is the total
earnings upon which the commission is based. So, for the $15k-$30K
possibility I have:
=if(D6<15000,"0",if(D630000,(15000*.30)),(d6-15000)*.30)
Excel's error says there are too many arguments. If an employee earns
$50K,
they would receive (15,000 * 25%) + (15,000 * 30%) + (20,000 * 35%). But
if
they earn $10,000, the commission is ($10K * 25%) and all the other levels
need to have a zero (instead of FALSE as is currently occurring). Any
help
on nesting IF functions would be greatly appreciated.
thanks, Dixie