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.
