How to use Excel to Calculate Standard VAT

  Durko 14:20 25 Nov 04
Locked

Could someone advise how I calculate standard VAT (e.g. 17.5%) payments when using MS Excel.

Many thanks.

  Nosmas 14:33 25 Nov 04

If you want to calculate only the VAT multiply the 'goods or services' value by 0.175. If you want to arrive at the VAT inclusive value multiply by 1.175.

If ever you want to calculate the net value of a figure that includes VAT then divide the latter by 1.175

  Peverelli 14:46 25 Nov 04

Highlight cells A1, A2 & A3. Go to Format > Cells and under the Number tab, select currency - click on OK.

Then, in cell A1 enter the amount.

In cell A2 type: =A1*0.175 (This will give you the VAT payable)

In cell A3 type: =A1*1.175 (This will give you the total cost)

  Simsy 16:25 25 Nov 04

to do this...

It's available here

click here

With instructions.

I hope it helps.

Note that I've just put the page there, just now, for this purpose. It wont be there for long!!

Regards,

Simsy

  Simsy 16:28 25 Nov 04

That this doesn't do any formatting, just the arithmetic.

Also, I should probably add that I've not tested it on anything other than my system which is win98se and Excel 2000.

Regards,

Simsy

  recap 16:49 25 Nov 04

One thing that may be useful is to make the percentage cell of the VAT value an absolute cell referenced cell.

If the cell is A1, an absolute cell referenced cell would look like this $A$1 in the formulae.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…