# Formula for Adding VAT in Excel (Apply with Easy Steps)

It is one kind of tax paid by the buyer. This is calculated based on the price of a product, then add to the product price. In this article, we will discuss the steps of how to add VAT in Excel using a formula.

## What Is VAT?

VAT stands for Value Added Tax. This tax is paid by the user instantly when purchasing any product. This is an indirect tax, as it has no direct relation to the taxpayerâ€™s income.

## Formula for Adding VAT in Excel and Its Application

The formulas related to VAT are as follows:

VAT = VAT Rate x Original Price

Price Including VAT = Original Price + VAT Rate x Original Price

Price Excluding VAT (Original Price) = Price Including VAT / (1+VAT Rate)

Now, we will discuss how to easily and effectively use a formula for adding VAT in Excel.

### ðŸ“Œ Step 1: Create Price List with VAT Rate and Form a Table

In this step, we will insert data and then form a table in the dataset.

• First, insert all data in the dataset.

• Select all cells of the dataset.
• Go to the InsertÂ tab.
• Select the Table option from the TablesÂ group.

• The Create Table window appears.
• Our selected range is shown here. We can modify our selection from here.
• Check My table has headersÂ option.

• Finally, press OK and look at the dataset.

As the table formed successfully, the Filter symbol is showing.

• Now, go to the Table DesignÂ tab.
• Uncheck Filter Button and Banded RowsÂ options.

### ðŸ“Œ Step 2: Calculate Corresponding VAT for Each Product

In this step, we will calculate VAT to add to the price.

• We put a formula on the VAT column to calculate VAT. Go to Cell E5 and put the following formula.
`=[@Price]*[@[VAT Rate]]`

• Now, press the EnterÂ button.

As we applied the Table feature, no need to use the Fill Handle option. Automatically VAT is calculated on the rest of the cells.

Read More: How to Calculate VAT from Gross Amount in Excel (2 Examples)

### ðŸ“Œ Step 3: Add VAT with Selling Price

In the last step, we will add VAT with the Price in Excel.

• We add VAT and Price on Cell F5. Put the following formula there.
`=[@Price]+[@VAT]`

• Now, press the EnterÂ button.

Finally, VAT is added to the Price.

We can apply an alternative formula to add the VAT with the Price.

• You can try this formula.
`=[@Price]+[@[VAT Rate]]*[@Price]`

Here, we multiply Price with VAT rate and add that value with Price in the same formula. We get the same result.

• You can also apply this formula.
`=[@Price]*(1+[@[VAT Rate]])`

Add 1 with the VAT Rate and multiply the result by the Price value.

## ðŸ’¬ Notes

Here, we used the Excel Table feature for some reasons. If we want to insert new data, we do not need to copy the formula again and again. Press the Tab button and the table will expand and enter new data.

## Conclusion

In this article, we described all the steps to add VAT with Price using Excel Formula. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.

## Related Articles

#### Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

5 Excel Tips
You Never Knew