Hi everyone,

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.