Add 15 percentage in Excel: 2 Quick & Easy Methods

Steps to Add 15 percent in Excel

Method 1: Using Excel Formula

Using an Excel formula for a 15% increase in a value is a straightforward method that provides instant results without any complex calculations. Here’s how you can add a 15% increase to any number in Excel. Suppose you have the original value mentioned in cell A1.

STEP 1: Click on an empty cell where you want the increased price.

STEP 2: Enter the following formula to calculate a 15% increase: =A*1.15

STEP 3: Press Enter.

Excel will show the value after the 15% has been added.

This approach is the reason why Excel is a widely used tool for professionals across disciplines.

Method 2: Use Paste Special

Excel’s Paste Special feature is a powerful tool for adding percentages in Excel. You can quickly add a percentage to a range of values in your spreadsheet using this method. This method will provide an accurate result and will require minimal effort. Follow the steps below to get the results:

STEP 1: List the original values in one column (e.g., column A).

STEP 2: Enter 1.15 in a blank cell. Press Ctrl + C to copy the value.

STEP 3: Select the range of cells where you want to add this percentage increase.

STEP 4: Press Alt + E + S to open the paste special dialog box.

STEP 5: In the Paste Special dialog, select Multiply. Click OK.

Excel multiplies each selected value by 1.15, effectively increasing each by 15%. This method prevents the need to create additional columns, thus maintaining a tidy worksheet.

FAQs

What is the formula for a 15% increase in Excel?

The formula to add 15 percent to a value is straightforward. Firstly, convert the percentage increase into decimal form, i.e., convert 15% to 0.15. Then, add 1 to that value and simply multiply it by the original value.

Here’s the formula: =OriginalNumber * (1 + PercentageIncrease)

How to make sure that the result is correct?

To get the correct result, make sure that the percentage increase value is properly formatted as a decimal. For example, to increase the number by 15%, you can multiply the original number by 1.5. Be sure to double-check the formula and validate the result.

How to use Paste Special to add a percentage to a value?

Paste special is a quick and easy way to add a percentage to a value.  Simply, convert the percentage to a decimal format, i.e., 15% to 1.15. Now, copy this value and select the range where you want to add 15%. Press Alt + E + S + M and click OK. The values will be increased by the percentage mentioned.

How to subtract a percentage from a number?

To reduce a value by a specific percentage in Excel, you can use this formula: =OriginalNumber * (1 - PercentageDecrease).The percentage decrease should be expressed in decimal format.