Calculate VAT in Microsoft Excel

How to calculate VAT in Excel Documents:

How, in Excel do I write the equation that will give me an ex VAT figure? Assuming I write the total in A1 and I want the ex VAT figure to appear in B1?

Here is the answer

In this particular point someone wants to work out what the VAT part of the figure is, and then leave themselves with a figure that is before VAT is applied. The calculation is based on the current VAT rate being 17.5%

The formula in cell B1 therefore would be:

=SUM((A1/117.5)*100)

If however you wanted to reverse the situation, example the figure in A1 does NOT include VAT, but you wanted the figure in B1 to be inclusive of VAT, then the formula in cell B1 would be as shown below:

=SUM((A1*117.5)/100)

Edited by MrTWS - 20 Jan 2010 at 4:34pm

Not quite but it is helpful - later on we will be expanding the computer forum categories so if you have some input to help peeps that will be very nice Mr H

Ah don't worry Hirvi - I'm sure something will come up and you're probably quite a smart person so your input is always appreciated