How can I change commision % after it pass certian number

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

Guest

i have class project where i am suppose to be sales manger and i am trying to
set up a pay plan for sale personals, the gross profit percentage changes
"20%" after the 12 sale the plan retroactive and go up to 25%.

i am trying to think if there is plan that changes the commission after it
hits that magic number

Thanks
 
Hi Ab shihab,

Not exactly sure what you want, but, here is a first try,
Gross Profit in A1
Number of sales in B1
Put this in C1 =IF(B1<=12,A1*0.2,A1*0.25)

HTH
Martin
 
Back
Top