Forum Discussion
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...
=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?
Thank you. Any chance Residential after April 2025?
This will do it (presuming your property price is in cell B1), and is more efficient than multiple nested IFs:
=IF(B1<=125000,0,MIN(125000,B1-125000)*2%+MAX(MIN(B1-250000,675000),0)*5%+MAX(MIN(B1-925000,575000),0)*10%+MAX(B1-1500000,0)*12%)
Muckeyethanks so much - legend
