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:
=A1*1.2
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:
=A1/1.2
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
Custom Software Development
Save time and money, while boosting productivity
Upgrade From Spreadsheets
Reduce errors and improve sharing of information.
Add a Comment