Need excel wiz for some help... Tiered Cumulative Commission Formula Thanks!

[NeedHelp555]

Hey guys Need a formula set up to do a commission table as structured below.


Incremental % Tier
2% $250.00
5% $500.00
9% $750.00
12% $1,000.00

Trying to set up a formula where if sales were to reach $250 the commission would be $5. Anything below $249 would be zero commission.

If sales were $350 then that would only be 2% total commission.

If sales were to reach above $500 lets say $550 however it would unlock the 5% tier and commission in this case would be ($250*2%)+($300*5%) = $17.5.

If $800 was reached it would unlock 9% tier (being above $750) and would be ($250*2%)+($250*5%)+($300*9%)= $44.5

Been at this for a bit and could really use some help. Thanks!

[Pete_UK]

Haven't you posted about this before? There is no need to duplicate threads (see Rule 05 in the Forum Rules at the top of the screen).

Pete

[6StringJazzer]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.