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.