[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

Posted on 2007-03-27
Medium Priority
259 Views
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
Question by:ljhodgett
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 7

Accepted Solution

dctuck earned 2000 total points
ID: 18798641
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

ID: 18798652
dctuck, I think he wants the VAT amount, not the original cost

MyTax = MyPrice - (MyPrice/1.175)
0

LVL 7

Expert Comment

ID: 18798661
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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
###### Suggested Courses
Course of the Month14 days, 8 hours left to enroll