[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

Calculate added tax cost.

Hi Experts,

I have more of a maths question really. I know how to add tax onto an amount but how do I work it out backwards. i.e. if a product costs £3.99 including tax and the tax rate is 17.5% how do I know the cost that has been added before coming to the price of £3.99.  I am using vb.net 2005

Many Thanks
Lee
0
ljhodgett
Asked:
ljhodgett
  • 2
1 Solution
 
dctuckCommented:
A product price including VAT is 100% of the price plus 17.5%, so you have a grand total of 117.5%.

Simply divide your figure by 117.5 and multiply by 100!

i.e. (3.99 / 117.5) * 100 = 3.40 (rounded up)
0
 
TimCotteeCommented:
dctuck, I think he wants the VAT amount, not the original cost

MyTax = MyPrice - (MyPrice/1.175)
0
 
dctuckCommented:
Sorry, yes... You can use the same as I had put, but multiply by 17.5 instead of 100, or use TimCottee's solution which amounts to the same thing
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now