The basic formula: multiply by 1 plus the percentage

To add a percentage to a number in a spreadsheet, multiply the original number by 1 plus the percentage as a decimal. If you want to add 15% to the number 100, the formula is =100*1.15, which gives you 115. The 1 represents the original amount, and the 0.15 is 15% expressed as a decimal.

You can also write this as =100+(100*0.15) — it gives the same result. This version makes it clearer what is happening: you are taking the original number, calculating 15% of it, and adding that amount to the original. Most people find the first version faster to type.

If the number you are adding a percentage to is in a cell rather than typed directly into the formula, replace the number with the cell reference. If 100 is in cell A1 and you want to add 15%, write =A1*1.15. If the percentage itself is in a cell — say, 15 is in cell B1 — write =A1*(1+B1/100). The /100 converts the percentage to a decimal.

Key Takeaways

  • The fastest formula is the original number multiplied by 1 plus the percentage as a decimal: =100*1.15 adds 15% to 100.
  • Use cell references instead of typing numbers directly so you can change the values later without rewriting the formula.
  • If the percentage is stored in a cell as a whole number (like 15 instead of 0.15), divide it by 100 in your formula.
  • You can copy a formula down a column to add the same percentage to many numbers at once.

Using cell references so you can change numbers later

When you use cell references in your formula instead of typing numbers directly, you can change the values without rewriting the formula. This matters when you are working with real data that changes — like prices, salaries, or inventory counts.

Set up your spreadsheet with the original numbers in one column (say, column A), the percentage in another cell (say, D1), and your formula in a third column (column C). In cell C1, write =A1*(1+$D$1/100). The dollar signs lock the reference to D1, so when you copy the formula down to C2, C3, and beyond, it always looks at D1 for the percentage but moves to A2, A3, and so on for the original numbers. If you later change the percentage in D1 from 15 to 20, all the results update automatically.

Without the dollar signs, the formula would shift both references as you copy it down, which usually breaks the calculation. The dollar signs tell the spreadsheet to keep that reference fixed.

Adding different percentages to different rows

Sometimes each row needs a different percentage added — for example, different product categories might have different markup rates. Put the percentage for each row in its own column, then reference that column in your formula.

If your original numbers are in column A, the percentages for each row are in column B, and you want the results in column C, write =A1*(1+B1/100) in cell C1. Copy this formula down the column. Each row will use its own percentage from column B. Row 1 uses B1, row 2 uses B2, and so on — the spreadsheet adjusts the references automatically as you copy.

Checking your work with a straightforward example

Before you use a formula on real data, test it with a number you can calculate by hand. If you want to add 10% to 50, the answer should be 55 (50 plus 5). Type =50*1.10 into an empty cell and press Enter. If you see 55, the formula is correct. If you see something else, check that you typed the formula exactly as shown.

Common mistakes include forgetting the equals sign at the start (the spreadsheet will treat it as text, not a formula), typing the percentage as a whole number instead of a decimal (writing 15 instead of 0.15), or misplacing parentheses. If your result looks wrong, click the cell and look at the formula bar at the top of the screen — it shows exactly what the spreadsheet is calculating.

Why this matters for budgets and pricing

Adding percentages to numbers is one of the most common tasks in spreadsheets because it shows up in almost every financial calculation. If you are tracking a budget and costs increase by 8%, you need to add 8% to each line item. If you are setting prices and want a 25% markup on cost, you add 25% to what you paid. If you are calculating a raise, you add a percentage to the current salary.

Once you understand how to write the formula, you can handle any of these situations. The structure stays the same: original number times (1 plus the percentage as a decimal). The only thing that changes is where the numbers come from — whether they are typed in, stored in cells, or pulled from another sheet.

Copying the formula to many cells at once

If you have 50 rows of numbers and you want to add the same percentage to all of them, you do not have to type the formula 50 times. Write the formula once in the first cell, then copy it down to the rest.

Click the cell with your formula (for example, C1). Look for the small square in the bottom-right corner of the cell — this is called the fill handle. Click and drag it down to the last row you need (C50). The spreadsheet copies the formula and adjusts the cell references automatically. If you prefer not to drag, you can also click the cell, copy it (Ctrl+C on Windows, Cmd+C on Mac), select the range where you want it (C1:C50), and paste (Ctrl+V or Cmd+V). Both methods give the same result.

Frequently Asked Questions

What if I want to subtract a percentage instead of add one?

Use the same structure but subtract instead of add. To subtract 15% from 100, write =100*0.85 (which is 1 minus 0.15). Or write =100-(100*0.15). Both give 85. The logic is the same: you are keeping a percentage of the original and removing the rest.

Can I add a percentage to a cell that already has a formula in it?

Yes. If cell A1 contains a formula that calculates a number, you can reference A1 in another formula just as you would reference a number typed directly. The spreadsheet calculates A1 first, then uses that result in your percentage formula.

What does the dollar sign do in a formula like $D$1?

The dollar signs lock that cell reference so it does not change when you copy the formula to other cells. Without them, the reference shifts as you copy down. Use dollar signs when you want a cell to stay the same (like a percentage that applies to all rows) and leave them off when you want the reference to move with each row.

How do I add a percentage that is written as a decimal, like 0.15 instead of 15?

If the percentage is already a decimal, do not divide by 100. Write =A1*(1+B1) instead of =A1*(1+B1/100). The spreadsheet treats 0.15 as 15% directly, so you just add it to 1 and multiply.