How can I change commision % after it pass certian number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ab_shihab - 01 Jul 2007 02:10 GMT

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

Reply to this Message

MartinW - 01 Jul 2007 03:07 GMT

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

>i have class project where i am suppose to be sales manger and i am trying
>to
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message