Hello,
I'm trying to come up with a formula that will pay commissions based on a tiered approach. So any sales that result in 65 to 95 would pay $10 each, any lower than 65 would be $8 each, then I would like to total this. Any suggestions?
Thanks in advance.
I'm trying to come up with a formula that will pay commissions based on a tiered approach. So any sales that result in 65 to 95 would pay $10 each, any lower than 65 would be $8 each, then I would like to total this. Any suggestions?
Thanks in advance.
Target | Amt per Acceptance | Total Commission |
15 | $8.00 | $120.00 |
25 | $8.00 | $200.00 |
35 | $8.00 | $280.00 |
45 | $8.00 | $360.00 |
55 | $8.00 | $440.00 |
65 | $10.00 | $650.00 |
75 | $10.00 | $750.00 |
85 | $10.00 | $850.00 |
95 | $10.00 | $950.00 |
105 | $15.00 | $1,575.00 |
115 | $15.00 | $1,725.00 |
125 | $15.00 | $1,875.00 |
135 | $15.00 | $2,025.00 |