Skip to main content

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! 

Reply


Terms & Conditions