Adding and Removing VAT in Excel with our VAT Calculator

Excel is the perfect tool if you want to add or remove VAT in your sales and purchasing calculations.

Our updated and improved VAT Calculator is now available as a complementary download.

It automates adding and removing VAT with Excel to help you with your VAT calculations.

The VAT Calculator gives:

  • The amount for each row, with and without VAT
  • The individual VAT amounts for each row.
  • Total Including VAT
  • Total Excluding VAT
  • Total VAT Amount
  • Flexible VAT rate in case it changes!

Value-Added Tax (VAT) is known as Goods and Services tax in some countries.  VAT has a long and winding history.  If you are feeling curious, here is the Wikipedia page on VAT!

How to add VAT in Excel

To Add VAT in Excel we use a formula which contains the multiplication operator, *.

e.g. If you want to add 20% VAT to £15 in cell A1, in cell B1, type in:


How to remove VAT in Excel

To remove VAT we instead use a formula with the division operator, /.

e.g. To remove 20% VAT from £18 in cell A1, in cell B1, type in:


To get all the nice totals, check out the formulas and formatting in the complementary download:

Check out more business spreadsheets.

Sign up for Excel Help, Data Tips and Business Admin Advice


* indicates required

Working Data will use the information you provide on this form to be in touch with you and to provide alerts to new blog posts, updates and marketing. Please let us know all the ways you would like to hear from us:

You can change your mind at any time by clicking the unsubscribe link in the footer of any email you receive from us, or by contacting us at We will treat your information with respect. For more information about our privacy practices please visit our website. By clicking below, you agree that we may process your information in accordance with these terms.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp's privacy practices here.

Custom Software Development

Save time and money, while boosting productivity

MS Access Support

Upgrades, fixes, new functions and reports.

Upgrade From Spreadsheets

Reduce errors and improve sharing of information. 

Add a Comment

Your email address will not be published. Required fields are marked *