The fastest way to add a percentage in Excel

To add a percentage to a number in Excel, multiply the original number by 1 plus the percentage as a decimal. If you want to add 15% to the value in cell A1, enter the formula =A1*1.15 in a new cell. Excel will calculate the result when ready.

The reason you use 1.15 instead of just 0.15 is that you are keeping the original amount and adding the percentage on top. Multiplying by 1.15 means "keep 100% of the original, plus add 15%." If you multiplied by only 0.15, you would get just 15% of the original number, not the original plus 15%.

You can also write this formula in a way that makes the percentage visible: =A1+(A1*0.15). This reads as "the original number plus 15% of the original number" and produces the same result. Many people find this version easier to understand when they come back to the spreadsheet later.

Key Takeaways

  • Multiply the original number by 1 plus the percentage as a decimal—for example, =A1*1.15 to add 15%.
  • You can also write =A1+(A1*0.15) if you want the calculation to be clearer when someone reads the formula.
  • If you need to add different percentages to many rows, create the formula once and copy it down to fill the rest of the column.
  • To add a percentage directly to a number without a formula, multiply the number by 1.15 on paper first, then type the result into the cell.

Setting up the formula for a single cell

Click on the cell where you want the result to appear. This should be a different cell from the one holding your original number, so you can see both the starting value and the new value with the percentage added.

Type the equals sign to start a formula. Then type the cell reference (like A1), an asterisk for multiplication, and 1 plus your percentage as a decimal. For 20%, type =A1*1.20. For 8%, type =A1*1.08. Press Enter, and Excel calculates the result.

If your original number is 100 and you use =A1*1.15, the result will be 115. If your original number is 50 and you use the same formula, the result will be 57.50. The formula adjusts automatically based on whatever number is in the cell you referenced.

Copying the formula down to multiple rows

When you have a list of numbers and need to add the same percentage to all of them, create the formula once in the first row, then copy it down. Click on the cell containing your formula. You will see a small square in the bottom right corner of the cell—this is the fill handle.

Click and drag that square down to the last row you want to fill. Excel copies the formula to each row and automatically adjusts the cell references. If your formula was =A1*1.15 in the first row, it becomes =A2*1.15 in the second row, =A3*1.15 in the third row, and so on.

Alternatively, click on the cell with the formula, copy it (Ctrl+C on Windows, Command+C on Mac), then select the range of cells below it and paste (Ctrl+V or Command+V). Both methods produce the same result.

Using a separate cell for the percentage itself

If you plan to change the percentage later, or if you want to add different percentages to the same list, store the percentage in its own cell. Put your percentage in cell C1—type 15 if you mean 15%, or 0.15 if you prefer the decimal form.

Then write your formula as =A1*(1+C1) if C1 contains 0.15, or =A1*(1+(C1/100)) if C1 contains 15. The second version is often clearer because you can read the percentage value directly without converting it mentally.

Now if you need to change the percentage from 15% to 20%, you only update the number in C1. Every formula that references C1 recalculates automatically. This saves time when you are testing different scenarios or when the percentage changes regularly.

Checking your work with a straightforward example

Test your formula with a number you can calculate by hand. If you want to add 10% to 100, the answer should be 110. Type 100 in cell A1, then enter =A1*1.10 in cell B1. Press Enter. If B1 shows 110, your formula is correct.

Try another example: add 25% to 80. The answer should be 100. Type 80 in A2, enter =A2*1.25 in B2, and press Enter. If B2 shows 100, you know the formula works.

These straightforward checks take 30 seconds and catch mistakes before you copy the formula across hundreds of rows. A small error in the formula can compound quickly when you explore it to many cells.

Common mistakes and how to avoid them

The most common error is forgetting the 1 in front of the decimal. If you type =A1*0.15 instead of =A1*1.15, you get 15% of the original number, not the original plus 15%. For a starting value of 100, this gives you 15 instead of 115.

Another mistake is using the wrong cell reference. If your numbers are in column A but you accidentally reference column B, the formula will either return 0 or an error. Double-check that the cell reference in your formula points to the cell containing the number you want to increase.

If you copy a formula and the results look wrong, check whether the cell references updated correctly. Click on one of the cells with the formula and look at the formula bar at the top of the screen. You should see that the row number changed (A1 became A2, A3, and so on) but the column stayed the same.

Adding percentages to prices or costs

In business spreadsheets, you often add percentages to calculate markups, tax, or tips. If a product costs $50 and you want to add a 40% markup, the formula =A1*1.40 gives you $70. If a meal costs $80 and you want to add 18% for tip, the formula =A1*1.18 gives you $94.40.

When working with money, format your cells as currency so the results display with a dollar sign and two decimal places. Right-click on the cell, choose Format Cells, select Currency, and click OK. This makes the spreadsheet easier to read and prevents confusion about whether a number represents dollars or cents.

If you are calculating tax on different items with different tax rates, store each tax rate in its own cell next to the item. This way you can see at a glance what rate was applied to each row, and you can update rates without searching through formulas.

Frequently Asked Questions

What if I want to subtract a percentage instead of adding it?

Use the same method but subtract instead of add. To subtract 15% from a number, use =A1*0.85 (which means keep 85% of the original). To subtract 20%, use =A1*0.80. You can also write =A1-(A1*0.20) if that is clearer to read.

Can I add different percentages to different rows?

Yes. Store each percentage in its own cell in a separate column, then reference that cell in your formula. For example, if percentages are in column C, use =A1*(1+C1) in the first row, then copy the formula down. Each row will use the percentage from its own row in column C.

What does the asterisk mean in the formula?

The asterisk (*) means multiply. In Excel, you use * for multiplication, / for division, + for addition, and - for subtraction. These symbols are called operators, and they tell Excel what calculation to perform.

How do I add a percentage to a number that is already a formula result?

Treat the cell containing the formula result the same way you would treat any other cell. If cell A1 contains a formula that produces a number, you can still reference A1 in another formula like =A1*1.15. Excel calculates A1 first, then uses that result in the new formula.

Can I type the percentage directly into the formula instead of referencing a cell?

Yes. Instead of =A1*1.15, you can type =A1*1.15 directly, or =A1+(A1*0.15). Both work. However, if you need to change the percentage later, you have to edit the formula. Using a separate cell for the percentage makes updates faster.