Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Stamp Duty Calculation

Copper Contributor

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;1500000}), {0.03;0.05;0.05;0.02})

 

I want to edit this formula so that if F2 is less than 40000 then the stamp duty = £0 regardless of the above formula.

 

Can anyone assist me please?

 

Thanks,

 

Pat

 

5 Replies
best response confirmed by Pat_Burrows1970 (Copper Contributor)
Solution

@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 

 

Thank you it worked.

 

You are a star!

You are welcome.

@OliverScheurich 

 

If anyone comes across this thread more recently, rates have now changed...

=IF(B4<40000,0,SUMPRODUCT(--(B4>{0;250000;925000;1500000}),(B4-{0;250000;925000;1500000}),{0;0.05;0.1;0.12}))

 

Very useful - thank you!
1 best response

Accepted Solutions
best response confirmed by Pat_Burrows1970 (Copper Contributor)
Solution

@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?

View solution in original post