View Single Post
  #1   Report Post  
Dixie
 
Posts: n/a
Default Nested IF functions and 3 conditions

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