How to Calculate VAT Tax – Excel & Google Sheets

This tutorial will demonstrate how to calculate VAT in Excel and Google Sheets.

calculate vat tax Main Function

Calculate VAT in Excel

VAT can be calculated in Excel using a simple formula.

calculate vat tax 1

This formula will only get the VAT amount based on a VAT rate of 10%.   When you type the formula, you can either type 10% or you can type 0.1 – both methods will return the same result.

To get the total value of the product, you would then need to add the Price + VAT together

calculate vat tax Total

You can also calculate the VAT in a formula without having a separate VAT column in your spreadsheet.

This formula will return a total price including the VAT amount.

calculate vat tax One Function

 

Calculate VAT in Google Sheets

You can calculate VAT in Google Sheets in the same way.

calculate vat tax Google Function

 

 

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!