# How do I add 10% in Excel?

**Here's how to do it:**

- Enter the numbers you want to multiply by 15% into a column.
- In an empty cell, enter the percentage of 15% (or 0.15), and then copy that number by pressing Ctrl-C.
- Select the range of cells A1:A5 (by dragging down the column).

A.

### How do I calculate VAT backwards?

**VAT calculation formula**for

**VAT**exclusion is the following: to

**calculate VAT**having the gross amount you should divide the gross amount by 1 +

**VAT**percentage (i.e. if it is 15%, then you should divide by 1.15), then subtract the gross amount, multiply by -1 and round to the closest value (including eurocents).

#### How do you subtract 20% from a price?

To**subtract**any percentage from a number, simply multiply that number by the percentage minus 100. To divide by**20**percent, multiply by 80 percent. To divide by 30 percent, multiply the number by 70 percent. Before beginning, determine the gross amount you want to use before**subtracting**a percentage.#### How do you add 10% to a price?

To increase a number by a**percentage**amount, multiply the original amount by 1+ the**percent**of increase. In the example shown, Product A is getting a**10 percent**increase. So you first**add**1 to the**10 percent**, which gives you 110**percent**. You then multiply the original**price**of 100 by 110**percent**.#### How much is the VAT?

Work out**how much VAT**you paid on your purchases. Different rates of**VAT**apply to different goods and services. There are currently three rates - the standard 20% (increased from 17.5% on 4 January 2011), a reduced rate charged at 5% and zero rate.

Updated: 18th September 2018