Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Stamp Duty Land Tax Formula/Calculator

1736 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Raphael1
4 - Data Explorer
4 - Data Explorer

Hi all, does anyone have a formula to calculate Stamp Duty Land Tax (UK) in Airtable? I attach the Excel formula that I previously used.

 

=SUMPRODUCT(--(A1>{125000;250000;925000;1500000}), (A1-{125000;250000;925000;1500000}), {0.02;0.03;0.05;0.02})+(A1*0.03)

Thanks in advance!

1 Reply 1
Soly
7 - App Architect
7 - App Architect

Hi @Raphael1 , 

To calculate the SDLT in Airtable you may try using the following script :

IF( purchase_price < 125000, 0,
  IF( purchase_price < 250000, (purchase_price - 125000) * 0.02,
    IF( purchase_price < 925000, (purchase_price - 250000) * 0.03 + 2500,
      IF( purchase_price < 1500000, (purchase_price - 925000) * 0.05 + 12500,
        (purchase_price - 1500000) * 0.02 + 54000
      )
    )
  )
)

Make sure you replace the purchase_price field with the one you use in your base. 

Let me know if that worked for you!