Forum Discussion

Pat_Burrows1970's avatar
Pat_Burrows1970
Copper Contributor
Oct 04, 2022
Solved

Stamp Duty Calculation

Hello,   I have a SUMPRODUCT formula to calculate stamp duty in the UK below where F2 = the purchase price of a property.    =SUMPRODUCT(--(F2>{0;250000;925000;1500000}),(F2-{0;250000;925000;1500...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Oct 04, 2022

    Pat_Burrows1970 

    =IF(F2<40000,0,SUMPRODUCT(--(F2>{0;250000;925000;1500000}),(F2-{0;250000;925000;1500000}),{0.03;0.05;0.05;0.02}))

     

    Does this return the expected result?

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 04, 2022
You are welcome.

Resources