Tiered Commission Calculation
I am trying to develop a way to calculate commission based upon a sales goal percentage. For instance, if the sales person meets less than 50%, they would receive 0% of Margin. If the sales person receives 50% they would receive 10% of Margin. If the sales person receives 65% they would receive 20% of Margin. If the sales person receives 80% they would receive 30% of margin.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Using conditional tests to output the correct multiplier would be the way to go
Using bested conditional if >65%, multiplier, if >50% ,multiplier, if <20%,0,0
cell*if(
Your not description on the setup I.e. If you are using vba, or it is a function of having a column tracking.....or how the data analysis is performed.
Using bested conditional if >65%, multiplier, if >50% ,multiplier, if <20%,0,0
cell*if(
Your not description on the setup I.e. If you are using vba, or it is a function of having a column tracking.....or how the data analysis is performed.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial