# How to Add a Percentage to a Price with an Excel Formula – 2 Methods

## Importance of Cell Number Formatting During the Percentage Calculation

To enter a percentage you have to use Number format.

Steps:

• Enter a decimal number (.12) in D5.

• Go to Home > Number and click the percent â€˜%â€™ symbol.

• The decimal number will be displayed as a percentage.

## How to Add the Percentage to the Price with an Excel Formula

### 1. Add Percentage to Price Applying Simple Formula

The dataset showcases a list of grocery items with their old price and the price increment percentage. Add the percentage to the old price and calculate the new price.

Formula 1:

The old price of the Whole Grain Pasta was \$10. The price increased by 12%. 1 will be added to 12%, which results in 112%. The older price \$10 is multiplied by 112% to get the new price (\$11.20).

Steps:

• Use the formula inÂ E5 and press Enter.
`=C5*(1+D5)`

• You will see the new price for Whole Grain Pasta. Drag down the Fill Handle (+) to see the new price of the other items.

• This is the output.

Formula 2:

Use the below formula to add percentages to the old price:

`=C5+C5*D5`

Formula 3:

Use Formula 1 in two steps.

Add 1 to the increased percentage.

Steps:

• Enter the formula in E5, press Enter, and use the Fill Handle.
`=1+D5`

• Use the formula in F5 and press Enter.
`=C5*E5`

• Drag down the Fill Handle to see the result in the rest of the cells.

Formula 4:

Multiply the old prices by increased percentages to see the increased amount in USD. Use the SUM function to add the increased amount.

Steps:

• Enter the formula in E5, press Enter, and use the Fill Handle.
`=C5*D5`

• Enter the formula inÂ F5.
`=SUM(C5+E5)`

• The new price for the first grocery item is displayed. Drag down the Fill Handle to see the result in the rest of the cells.

### Method 2 – Using the Excel â€˜Paste Specialâ€™ Option to Add a Percentage to the Price

Steps:

• Enter the formula in E5, press Enter, and drag down the Fill Handle.
`=1+D5`

• Select the Old Prices (C5:C12) and copy them by pressing Ctrl + C.

• Select E5:E12 and right-click. Click Paste Special.

• In the Paste Special dialog box, click Multiply in Operation.
• Click OK.

• The new prices will be displayed.

## Deduct the Percentage from the Price

To subtract a percentage from the original price, subtract the percentage from 1 and multiply the result by the original price.

Steps:

• Enter the formula in E5.
`=C5*(1-D5)`

• Press Enter, copy the formula to the rest of the cells using the Fill Handle, and see the new prices.

## Things to Remember

âž¤ Add parenthesis in the formulas: =C5*(1-D5).Â  Excel performs multiplication operations before subtraction or addition.

âž¤ You can also access Paste Special pressing Ctrl + Alt + V.

Download Practice Workbook

Download the practice workbook.

## Related Articles

<< Go Back to Add Percentage to a Number in Excel | Calculating Percentages in Excel | How to Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Hosne Ara

Hosne Ara is a materials and metallurgical engineer who loves exploring Excel and VBA programming. To her, programming is like a time-saving superhero for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B. Sc. in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, she's shifted gears and now works as a content developer. In this role, she... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF