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 3 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.

Share and Enjoy:

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?

Dave Discovers