Italian Excel formula
Aggiungere IVA: =A2*(1+B2/100)
Scorporare IVA: =A2/(1+B2/100)Excel formula for VAT and reverse VAT
Use these formulas to calculate net amount, VAT and gross total.
English Excel formula
Add VAT: =A2*(1+B2/100)
Reverse VAT: =A2/(1+B2/100)
Example
A2=100 and B2=22: VAT-included total is 122.
Common errorDo not simply subtract 22% from the gross total: divide by 1.22.
How it works
To add VAT, multiply by 1 plus rate/100.
To reverse VAT, divide by 1 plus rate/100.
Frequently asked questions
How do I add 22% VAT?
Use =A2*1.22.
How do I reverse VAT?
Use =A2/1.22.