Solved

Calculate added tax cost.

Posted on 2007-03-27
3
252 Views
Last Modified: 2010-04-23
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
Comment
Question by:ljhodgett
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
dctuck earned 500 total points
Comment Utility
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
 
LVL 43

Expert Comment

by:TimCottee
Comment Utility
dctuck, I think he wants the VAT amount, not the original cost

MyTax = MyPrice - (MyPrice/1.175)
0
 
LVL 7

Expert Comment

by:dctuck
Comment Utility
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
This video discusses moving either the default database or any database to a new volume.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now