How To Calculate Vat Using Excel

Tagged with: calculate, excel, formula, spreadsheet, vat

Posted by Dave on Saturday, February 28, 2009, 5:19

This item was posted in How To and has 10 Comments so far.

Hello there! If you are new here, you might want to subscribe to the RSS feed for updates on this topic.

You can calculate 17.5% vat in Microsoft Excel by using this formula.

Number x7 /47

You multiply the number by 7 and divide by 47 to get the vat amount.

You can also calculate the new UK 15% vat rate in Microsoft Excel by using this formula.

Number x3 /23

You multiply the number by 3 and divide by 23 to get the vat amount.

You can calculate 20% vat in Microsoft Excel by using this formula.

Number x1 /6

You multiply the number by 1 and divide by 6 to get the vat amount.

Be Sociable, Share!

You can follow this post through RSS 2.0 feed.

Chris

16 September, 2009, 15:35

Thank you so much!

Gotta love simple solutions that work
Precious

14 April, 2010, 17:43

Thank u so much! I gotten something dt has been given me problem.
Catherine

22 June, 2010, 14:59

How do you calculate 20% VAT then?
gill

6 October, 2010, 14:56

what is the formula for 20% VAT please.
jane

12 October, 2010, 15:09

How do you calculate 20%
Robin

29 December, 2010, 17:06

20% VAT formula is as above, but substitute – number x1/6
Dave

4 January, 2011, 10:45

I’ve added the forulma to calculate 20% VAT.
Eileen Donnelly

13 January, 2011, 18:21

This is a great help, wish I’d found you sooner.So simple now I know that to find 20% is straight forward gross divide by 6! BIG THANKYOU!!
Wendy

13 April, 2011, 14:58

Thank you Dave! I’d been trying to adapt the previous year’s formula with no luck, so much appreciated
Kuba

24 May, 2011, 13:58

Fantastic! Simple and effective1

Dave Discovers