 # Formula to Remove the VAT in Excel

Last Updated on 11/05/2023 by Frédéric LE GUEN

How to remove the VAT from a price with Excel?

If you want to calculate VAT in Excel, you will find the formulae in this article.

## Calculate the price excluding VAT

The formula to calculate the price of the product, without VAT, is the following.

=Price with VAT/(1+Tax rate)

=B4/(1+\$C\$1)

You divide the price of the product by 1+ the VAT rate.

## Remove VAT of the price

The formula to remove VAT, is a little bit more complex with Excel. The formula is the following:

=(Full price * Tax rate)/(1+Tax rate)

=(B4*\$C\$1)/(1+\$C\$1)

Like this, in column D, you have the price without VAT.

# Formula to Remove the VAT in Excel

Last Updated on 11/05/2023 by Frédéric LE GUEN

How to remove the VAT from a price with Excel?

If you want to calculate VAT in Excel, you will find the formulae in this article.

## Calculate the price excluding VAT

The formula to calculate the price of the product, without VAT, is the following.

=Price with VAT/(1+Tax rate)

=B4/(1+\$C\$1)

You divide the price of the product by 1+ the VAT rate.

## Remove VAT of the price

The formula to remove VAT, is a little bit more complex with Excel. The formula is the following:

=(Full price * Tax rate)/(1+Tax rate)

=(B4*\$C\$1)/(1+\$C\$1)

Like this, in column D, you have the price without VAT.