VAT calculator
Add VAT to a price, or remove VAT to find the price without it, at your country's rate or any rate. GST works the same way.
Standard rates, checked October 2026
Adding 20% VAT to 100.00 gives 120.00 inc. VAT, of which 20.00 is VAT.
- Price ex. VAT
- 100.00
- VAT at 20%
- 20.00
- Price inc. VAT
- 120.00
For guidance only, not financial advice. Real offers depend on fees, taxes and terms. Check the exact figures with your bank, lender or accountant before you decide.
Formulas
How to add VAT to a price
To add VAT, multiply the price ex. VAT by 1 plus the VAT rate written as a decimal. At 20%, that means multiplying by 1.20:
price inc. VAT = price ex. VAT × (1 + rate)
- Write the rate as a decimal: 20% is 0.20, 19% is 0.19, 5% is 0.05.
- Add 1 to it: 1.20.
- Multiply the price ex. VAT by that number: 100 × 1.20 = 120.
- The VAT is the difference, or the price times the rate: 100 × 0.20 = 20.
| Price ex. VAT | Rate | Calculation | VAT | Price inc. VAT |
|---|---|---|---|---|
| 100.00 | 20% | 100.00 × 1.20 | 20.00 | 120.00 |
| 49.99 | 20% | 49.99 × 1.20 | 10.00 | 59.99 |
| 250.00 | 19% | 250.00 × 1.19 | 47.50 | 297.50 |
| 400.00 | 25% | 400.00 × 1.25 | 100.00 | 500.00 |
| 80.00 | 10% | 80.00 × 1.10 | 8.00 | 88.00 |
Amounts are rounded to two decimals for display: 49.99 × 1.20 is 59.988, which is 59.99. Whether VAT is rounded on each line of an invoice or only on its total is set by your tax authority's rules, so a long invoice can differ from a quick calculation by a cent or two.
How to remove VAT from a price
To remove VAT, divide the price inc. VAT by 1 plus the rate. This is sometimes called reverse VAT:
price ex. VAT = price inc. VAT ÷ (1 + rate)
- Write the rate as a decimal and add 1: 20% gives 1.20.
- Divide the price inc. VAT by that number: 120 ÷ 1.20 = 100.
- The VAT is what you took off: 120 − 100 = 20.
| Price inc. VAT | Rate | Calculation | Price ex. VAT | VAT inside |
|---|---|---|---|---|
| 120.00 | 20% | 120.00 ÷ 1.20 | 100.00 | 20.00 |
| 59.99 | 20% | 59.99 ÷ 1.20 | 49.99 | 10.00 |
| 119.00 | 19% | 119.00 ÷ 1.19 | 100.00 | 19.00 |
| 500.00 | 25% | 500.00 ÷ 1.25 | 400.00 | 100.00 |
| 99.00 | 21% | 99.00 ÷ 1.21 | 81.82 | 17.18 |
The common mistake: taking 20% off a price inc. VAT. 20% of 120 is 24, which would leave 96, but the VAT in 120 is only 20. VAT is charged on the price ex. VAT, so it has to come off by dividing, not by subtracting the rate.
Multipliers for common VAT rates
Multiply by the number in the second column to add VAT, and divide by it to remove VAT. The last column is the share of a price inc. VAT that is VAT, a shortcut for finding the VAT inside a price in one step.
| VAT rate | Add VAT: multiply by | Remove VAT: divide by | VAT share of the price inc. VAT |
|---|---|---|---|
| 5% | 1.05 | 1.05 | 4.76% |
| 10% | 1.10 | 1.10 | 9.09% |
| 19% | 1.19 | 1.19 | 15.97% |
| 20% | 1.20 | 1.20 | 16.67% |
| 21% | 1.21 | 1.21 | 17.36% |
| 23% | 1.23 | 1.23 | 18.7% |
| 25% | 1.25 | 1.25 | 20% |
At 20%, the VAT is 1/6 of the price inc. VAT; at 25%, exactly 1/5. That is why, in countries with 25% VAT, "20% of the shop price is tax" is right: the rate and the share are different numbers.
Adding VAT in a spreadsheet
With the price in cell A2 and a 20% rate, =A2*1.2 adds VAT and =A2/1.2 removes it, in Excel, Google Sheets and Numbers alike. Put the rate in its own cell, say B1, and =A2*(1+B1) works for any rate.
VAT is a percentage on top of a price, so the percentage calculator gives the same answers with "Y plus X%". For a sale price that already includes VAT, the discount calculator works out the saving.
VAT and GST rates by country
Rates checked October 2026. These are the standard rates, from the European Commission for EU countries and from each country's tax authority for the rest. Most countries also have reduced rates, for example for food, books or transport, which are not listed here.
| Country | Tax | Standard rate |
|---|---|---|
| Australia | GST | 10% |
| Austria | VAT | 20% |
| Belgium | VAT | 21% |
| Bulgaria | VAT | 20% |
| Canada (federal GST only) | GST | 5% |
| Croatia | VAT | 25% |
| Cyprus | VAT | 19% |
| Czechia | VAT | 21% |
| Denmark | VAT | 25% |
| Estonia | VAT | 24% |
| Finland | VAT | 25.5% |
| France | VAT | 20% |
| Germany | VAT | 19% |
| Greece | VAT | 24% |
| Hungary | VAT | 27% |
| Ireland | VAT | 23% |
| Italy | VAT | 22% |
| Latvia | VAT | 21% |
| Lithuania | VAT | 21% |
| Luxembourg | VAT | 17% |
| Malta | VAT | 18% |
| Netherlands | VAT | 21% |
| New Zealand | GST | 15% |
| Norway | VAT | 25% |
| Poland | VAT | 23% |
| Portugal | VAT | 23% |
| Romania | VAT | 21% |
| Singapore | GST | 9% |
| Slovakia | VAT | 23% |
| Slovenia | VAT | 22% |
| South Africa | VAT | 15% |
| Spain | VAT | 21% |
| Sweden | VAT | 25% |
| Switzerland | VAT | 8.1% |
| United Arab Emirates | VAT | 5% |
| United Kingdom | VAT | 20% |
In Canada, several provinces charge a harmonized sales tax (HST) instead of the 5% federal GST, and others add their own sales tax, so check the rate for your province.
More calculators
Other quick calculators
- Percentage calculatorX% of Y, what percent, reverse percentages, percentage change and difference.
- Discount calculatorSale prices, savings and percent off, including stacked discounts.
- Tip calculatorTip and total for any bill, split between people, with rounding up.
- Mortgage calculatorMonthly payment, loan amount and interest from the home price and down payment.
- Loan calculatorCar and personal loans: monthly payment, total interest and a full schedule.
- Compound interest calculatorHow savings grow with interest and regular deposits.
- Average calculatorMean, median, mode, range and standard deviation of a list of numbers.
- Age calculatorExact age in years, months and days, and the days until the next birthday.
- Days and weeks between datesDays, weeks and business days between two dates, or a date plus or minus days.
- BMI calculatorBody mass index in metric or imperial units, with the healthy weight range.
- Wind speed converterConvert m/s, km/h, mph and knots, with the Beaufort scale and hurricane categories.
Frequently asked questions
How do I add VAT to a price?
Multiply the price ex. VAT by 1 plus the rate as a decimal. At 20%, multiply by 1.20: 100 ex. VAT becomes 120 inc. VAT, of which 20 is VAT.
What is 20% VAT on 100?
20. Add it to the price and 100 ex. VAT becomes 120 inc. VAT. At other rates, the VAT on 100 is simply the rate itself: 19 at 19%, 25 at 25%.
How do I remove VAT from a price (reverse VAT)?
Divide the price inc. VAT by 1 plus the rate. At 20%, divide by 1.20: 120 inc. VAT is 100 ex. VAT. Don't subtract 20% of the price inc. VAT, which would give 96 and understate the price ex. VAT.
Why can't I just take 20% off to remove VAT?
Because VAT is calculated on the price ex. VAT, not on the price inc. VAT. The VAT inside a price that includes 20% VAT is 1/6 of that price (about 16.67%), not 20%.
What does reverse VAT mean?
Working backwards from a price inc. VAT to the price ex. VAT and the VAT inside it, which is what "Remove VAT (reverse VAT)" does. It is not the same as the reverse charge, a rule under which a business buyer, rather than the seller, accounts for the VAT on some sales between businesses.
How do I add VAT in Excel or Google Sheets?
With the price ex. VAT in A2 and 20% VAT, =A2*1.2 gives the price inc. VAT and =A2*0.2 the VAT. To remove VAT from a price inc. VAT in A2, use =A2/1.2 for the price ex. VAT and =A2-A2/1.2 for the VAT. For another rate, replace 1.2 with 1 plus the rate as a decimal.
Are the VAT and GST rates up to date?
The list shows standard rates, checked in October 2026 against the European Commission's list for EU countries and each country's tax authority for the rest. Rates change from time to time and many countries have reduced rates for food, books, transport and more, so check your tax authority's website for the rate that applies to you. You can always enter a custom rate.
Is VAT the same as sales tax?
Not quite. VAT (or GST) is charged at every step of the supply chain, with businesses reclaiming the VAT they pay, and is usually included in shop prices. US sales tax is charged only at the final sale and usually added at the checkout.