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!
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:
Sign up for Excel Help, Data Tips and Business Admin Advice
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.