Skip to content

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.

What do you want to do?

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)

  1. Write the rate as a decimal: 20% is 0.20, 19% is 0.19, 5% is 0.05.
  2. Add 1 to it: 1.20.
  3. Multiply the price ex. VAT by that number: 100 × 1.20 = 120.
  4. The VAT is the difference, or the price times the rate: 100 × 0.20 = 20.
Worked examples of adding VAT
Price ex. VATRateCalculationVATPrice inc. VAT
100.0020%100.00 × 1.2020.00120.00
49.9920%49.99 × 1.2010.0059.99
250.0019%250.00 × 1.1947.50297.50
400.0025%400.00 × 1.25100.00500.00
80.0010%80.00 × 1.108.0088.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)

  1. Write the rate as a decimal and add 1: 20% gives 1.20.
  2. Divide the price inc. VAT by that number: 120 ÷ 1.20 = 100.
  3. The VAT is what you took off: 120 − 100 = 20.
Worked examples of removing VAT
Price inc. VATRateCalculationPrice ex. VATVAT inside
120.0020%120.00 ÷ 1.20100.0020.00
59.9920%59.99 ÷ 1.2049.9910.00
119.0019%119.00 ÷ 1.19100.0019.00
500.0025%500.00 ÷ 1.25400.00100.00
99.0021%99.00 ÷ 1.2181.8217.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 rateAdd VAT: multiply byRemove VAT: divide byVAT share of the price inc. VAT
5%1.051.054.76%
10%1.101.109.09%
19%1.191.1915.97%
20%1.201.2016.67%
21%1.211.2117.36%
23%1.231.2318.7%
25%1.251.2520%

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.

CountryTaxStandard rate
AustraliaGST10%
AustriaVAT20%
BelgiumVAT21%
BulgariaVAT20%
Canada (federal GST only)GST5%
CroatiaVAT25%
CyprusVAT19%
CzechiaVAT21%
DenmarkVAT25%
EstoniaVAT24%
FinlandVAT25.5%
FranceVAT20%
GermanyVAT19%
GreeceVAT24%
HungaryVAT27%
IrelandVAT23%
ItalyVAT22%
LatviaVAT21%
LithuaniaVAT21%
LuxembourgVAT17%
MaltaVAT18%
NetherlandsVAT21%
New ZealandGST15%
NorwayVAT25%
PolandVAT23%
PortugalVAT23%
RomaniaVAT21%
SingaporeGST9%
SlovakiaVAT23%
SloveniaVAT22%
South AfricaVAT15%
SpainVAT21%
SwedenVAT25%
SwitzerlandVAT8.1%
United Arab EmiratesVAT5%
United KingdomVAT20%

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.

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.