Formula calculation using date fields

[Raphael1]

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!

[Soly]

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!