Im trying to put together a payroll base for my small start-up but Im finding it quite challenging dealing with the income tax calculation bit which requires the use of a progressive tax bracket system.
The income tax bracket system has the following rules -
Chargeable Income Rate (%)
First 319.00 0.0%
Next 100 5.0%
Next 120 10.0%
Next 3,000 17.5%
Next 16,461 25%
Exceeding 20,000 30%
Since there isnt any vlookup in Airtable like in Excel making an if statement is impossible. I am pretty sure there is a simpler way to go about it but I just dont have the insight yet.
Any help is totally appreciated.