How to Add 20 Percent to a Price in Excel – 2 Methods

The following dataset showcases clothes items’ prices.


Method 1 – Using a Formula to Add 20 Percent to a Price in Excel

A new column, ‘New Price’, was created.

Formula 1:

  • In D7 enter the following formula:
=C7*(1+$D$4)
  • Or this formula:
=C7+C7*$D$4
  • Press Enter to see the output.

Formula to Add 20 Percent to a Price in Excel

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

Formula to Add 20 Percent to a Price in Excel

This is the output.

Formula to Add 20 Percent to a Price in Excel

Formula 2:

In this formula, after adding 20 percent, the old price will be 120%.

Formula to Add 20 Percent to a Price in Excel

  • Enter the following formula in D8.
=C8*$D$5
  • Press Enter.

Formula to Add 20 Percent to a Price in Excel

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

Formula to Add 20 Percent to a Price in Excel

This is the output.

Formula to Add 20 Percent to a Price in Excel

Formula 3:

Calculate the increased amount and sum it to the price. A new column was added.

  • Enter the following formula in D7.
=C7*$E$4
  • Press Enter.

Formula to Add 20 Percent to a Price in Excel

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

Formula to Add 20 Percent to a Price in Excel

This is the output.

To calculate the new price:

  • Enter the following formula in E7:
=SUM(C7:D7)
  • Press Enter to see the result.

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

This is the output.

Formula to Add 20 Percent to a Price in Excel

Related Content: How to Subtract a Percentage in Excel


Method 2 – Applying the Paste Special command to Add 20 Percent to a Price in Excel

Steps:

  • Enter the following formula in D8 which contains the increased percentage.
=$D$5
  • Press Enter to see the result.

Paste Special to Add 20 Percent to a Price in Excel

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

Paste Special to Add 20 Percent to a Price in Excel

  • Copy C8:C14.

Paste Special to Add 20 Percent to a Price in Excel

  • Select D8 and right-click.
  • Select Paste Special in the context menu.
  • You can also press Ctrl+Alt+V to open the Paste Special dialog box.

Paste Special to Add 20 Percent to a Price in Excel

  • Check All in Paste.
  • Check Multiply in Operation.
  • Click OK.

This is the output.


Things to Remember

  • Use an Absolute Reference.

Download Practice Workbook

Download the free Excel template here and practice.


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!
Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo