I would guess that something like this will suit your needs:
J K L
1 Threshold Marginal Rate Diff. Rate
2 0 30% =K2
3 100000 33% =K3-K2
4 300000 35% =K4-K3
Now, assume your monthly sales start in B2, with year-to-date sales in
C2. Then the first month's commission is
D2: =SUMPRODUCT(--(C2$J$2:$J$4),(C2-$J$2:$J$4),$L$2:$L$4)
subsequent months' commissions will then just be the total calculated
commission, less the commission paid to date:
D3: =SUMPRODUCT(--(C3$J$2:$J$4),(C3-$J$2:$J$4),$L$2:$L$4) - D2
Copy D3 down as far as necessary.
In article ,
asdfasdf wrote:
Thanks for the link Aladin,
I checked the site out and it is on the right track, but there are
differences that I can't work out.
Here is what I tried to work with from McGimpsey's.
|