Hello I am trying to create an excel table to calculate a commission structure.
Here is the structure that I am working with:
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
The difficulty that I am finding is because anything from 0£ to £9000 gives 0% commission. Then anything value billed from £9000 to £29999 will give a commission of 10%, etc.
So for example if £34k is billed this would give a commission of £0 + £2100 + £600 = £2700 total.
Can anyone give me the formula that I should use that would mean just entering a value in a cell, and it being calculated automatically?
Thanks in advance!
Here is the structure that I am working with:
£0k to £9k | 0% | £0.00 | |
£9k - £29999 | 10% | £2,100.00 | |
£30k - £44999 | 15% | £2,250.00 | |
£45k - £59999 | 20% | £3,000.00 | |
£60k+ | 25% | uncapped |
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
The difficulty that I am finding is because anything from 0£ to £9000 gives 0% commission. Then anything value billed from £9000 to £29999 will give a commission of 10%, etc.
So for example if £34k is billed this would give a commission of £0 + £2100 + £600 = £2700 total.
Can anyone give me the formula that I should use that would mean just entering a value in a cell, and it being calculated automatically?
Thanks in advance!