Hi,
I need to calculate the bonus that will be applied in addition to the normal 3% commission. The tiers are:
35000-50000 3.5% (bonus is only on amount within 35-50k)
50000-75000 5.0%
75000-100000 10.0%
100000-125000 15.0%
I need to be able to say for example: 65000 commission would be a bonus of 1275.00. Total payout: 66275. What would be the best way to set up a formula for this?
I need to calculate the bonus that will be applied in addition to the normal 3% commission. The tiers are:
35000-50000 3.5% (bonus is only on amount within 35-50k)
50000-75000 5.0%
75000-100000 10.0%
100000-125000 15.0%
I need to be able to say for example: 65000 commission would be a bonus of 1275.00. Total payout: 66275. What would be the best way to set up a formula for this?