Our updated and improved VAT Calculator is now available as a complementary download.
It automates adding and removing VAT to help you with your VAT calculations.
|It shows you:
Want To Add VAT Calculations To Your Own Spreadsheet?
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:
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:
Want some more tips and examples of how to use Excel to make your work easier?
Subscribe to our Newsletter for examples of Excel Spreadsheets, Business Admin Tips and Databases.