I need some help
(don't worry about the dutch words, not important for the question)
So I'm making a sheet that can keep my income and costs every month and calculate my taxes etc automaticly.
Fot taxes and other stuff in Belgium we use a system based on net income according to the following table;
<tbody style="box-sizing: border-box;">
</tbody>
So, what I can't find is how to formulate in 1 cell that the % tax has to be according to this table?
Thanks for helping!
(don't worry about the dutch words, not important for the question)
So I'm making a sheet that can keep my income and costs every month and calculate my taxes etc automaticly.
Fot taxes and other stuff in Belgium we use a system based on net income according to the following table;
Belastingschijf | Inkomensschijf | Tarief belasting |
Schijf 1 | € 0 tot €12 990 | 25% |
Schijf 2 | € 12 990,01 t/m € 22 290 | 40% |
Schijf 3 | € 22 290,01 t/m € 39 660 | 45% |
Schijf 4 | Meer dan 39 660,01 euro | 50% |
<tbody style="box-sizing: border-box;">
</tbody>
So, what I can't find is how to formulate in 1 cell that the % tax has to be according to this table?
Thanks for helping!