Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 31, 2022 02:56 AM
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!
Dec 31, 2022 07:18 AM
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!