Formula to Remove the VAT in Excel

Formula to Remove the VAT in Excel
Last Updated on 04/08/2023
Reading time: < 1 minute

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.

1 Comment

  1. Seth
    31/08/2023 @ 00:06

    Sorry but it doesn't make sense to me, this works for me.

    ="cell of the price"-("cell of the price"/1."VAT Rate")

    20% VAT
    =A1-(A1/1.2)

    10% VAT
    =A1-(A1/1.1)

    5% VAT
    =A1-(A1/1.05)

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Formula to Remove the VAT in Excel

Reading time: < 1 minute
Last Updated on 04/08/2023

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.

1 Comment

  1. Seth
    31/08/2023 @ 00:06

    Sorry but it doesn't make sense to me, this works for me.

    ="cell of the price"-("cell of the price"/1."VAT Rate")

    20% VAT
    =A1-(A1/1.2)

    10% VAT
    =A1-(A1/1.1)

    5% VAT
    =A1-(A1/1.05)

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *