Jeffreyxx01
Board Regular
- Joined
- Oct 23, 2017
- Messages
- 156
Hi guys,
I am trying to workout a bonus formula, but got stuck on,
I want to see in the formula column, if I change the number in red (100), the fomula would show for the range the bonus, as for example, 45 - 36 = 9 then max payout is 450, but i want to see inbetween if there is for example 40, then it would be 50 times 4 = 200,
Thanks for the help
<colgroup><col span="5"><col><col></colgroup><tbody>
</tbody>
I am trying to workout a bonus formula, but got stuck on,
I want to see in the formula column, if I change the number in red (100), the fomula would show for the range the bonus, as for example, 45 - 36 = 9 then max payout is 450, but i want to see inbetween if there is for example 40, then it would be 50 times 4 = 200,
Thanks for the help
Number | 100 | |||||
Min | Max | Tier Range | Bonus | Payout | Formula here | |
0 | 35 | 0 | 0 | |||
36 | 45 | 9 | 50 | 450 | ||
45 | 54 | 9 | 100 | 900 | ||
54 | 63 | 9 | 200 | 1800 | ||
63 | 100 | 37 | 300 | 11100 |
<colgroup><col span="5"><col><col></colgroup><tbody>
</tbody>