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

Calculate VAT in Excel

VAT can be calculated in Excel using a simple formula.

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

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 in Google Sheets

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