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 |
