We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
PLEASE READ BEFORE POSTING: Hello Forumites! In order to help keep the Forum a useful, safe and friendly place for our users, discussions around non-MoneySaving matters are not permitted per the Forum rules. While we understand that mentioning house prices may sometimes be relevant to a user's specific MoneySaving situation, we ask that you please avoid veering into broad, general debates about the market, the economy and politics, as these can unfortunately lead to abusive or hateful behaviour. Threads that are found to have derailed into wider discussions may be removed. Users who repeatedly disregard this may have their Forum account banned. Please also avoid posting personally identifiable information, including links to your own online property listing which may reveal your address. Thank you for your understanding.
Reformed Stamp Duty - Excel Calc?
Keekles
Posts: 154 Forumite
Hi all,
I appreciate this isn't an IT / Excel forum however I'm not fond of registering to a new forum to ask one question - and I'm sure someone here has the knowledge!
Given MSE's main article regarding stamp duty is absolutely correct; the link sent me to the post dated back in 2013.
Regardless. I used to use a 'calculator' on Excel in which I had specified % rates assigned to each rate. So if cell = £245,000, the figure displayed from a LOOKUP formula would be 245000*0.01 equating to £2,450.
With the new incremental tax, just wondering if anyone had the knowhow or resource to calculate 2% of the first £125,000 (125-250), 5% of the next £675k and so on..
Using the magnificent:rotfl:Excel 2003.
Thanks!
I appreciate this isn't an IT / Excel forum however I'm not fond of registering to a new forum to ask one question - and I'm sure someone here has the knowledge!
Given MSE's main article regarding stamp duty is absolutely correct; the link sent me to the post dated back in 2013.
Regardless. I used to use a 'calculator' on Excel in which I had specified % rates assigned to each rate. So if cell = £245,000, the figure displayed from a LOOKUP formula would be 245000*0.01 equating to £2,450.
With the new incremental tax, just wondering if anyone had the knowhow or resource to calculate 2% of the first £125,000 (125-250), 5% of the next £675k and so on..
Using the magnificent:rotfl:Excel 2003.
Thanks!
0
Comments
-
=sumproduct(--(a1>{125000;250000;925000;1500000}), (a1-{125000;250000;925000;1500000}), {0.02;0.03;0.05;0.02})0
-
I have absolutely no idea why that copied and pasted in lower case (not that it makes a difference). Windows works in mysterious ways!0
-
Or you could just...
http://www.hmrc.gov.uk/tools/sdlt/land-and-property.htm0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 349.8K Banking & Borrowing
- 252.6K Reduce Debt & Boost Income
- 453K Spending & Discounts
- 242.7K Work, Benefits & Business
- 619.5K Mortgages, Homes & Bills
- 176.3K Life & Family
- 255.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 15.1K Coronavirus Support Boards