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 1 Comment 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.

Dave Discovers