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!
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!
Great discussion — stamp duty and land tax calculations can get really complex depending on region, slabs, and exemptions. If someone’s looking for real estate or land record tools in Andhra Pradesh, they can also check MeeBhoomi AP via website https://meebhoomi-ap.net/ — it helps with verifying land records before applying such formulas.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.