Forum Discussion
Tiered Commission Formula
What would be the most efficient formula for calculating Tiered Commission? So for sales of products 1~20, the commission would be $300 per product. Then from 21~30, it would be $400 per, 31~40, $...
I'd create a table with the thresholds and the increase in commission per item.
The formula in B2 is
=SUMPRODUCT((A2>$E$2:$E$19)*(A2-$E$2:$E$19),$G$2:$G$19)