Solved

Calculate added tax cost.

Posted on 2007-03-27
3
253 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
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

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

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

Expert Comment

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Convert string to date 3 55
.Net Web Site Password specs 2 31
Put window Form inside tab page 10 26
Get size of each directory on each mapped drive 5 18
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…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

939 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

9 Experts available now in Live!

Get 1:1 Help Now