The basic formula for adding a percentage

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

The reason you multiply by 1.15 instead of just .15 is that you want to keep the original amount and add the percentage on top of it. Multiplying by just .15 would give you only 15% of the original, not the original plus 15%.

This same logic works whether you are calculating a tip, a price increase, a tax amount, or a commission. The structure stays the same: original amount times (1 plus the percentage as a decimal).

Key Takeaways

  • The formula to add a percentage to an amount is: original amount × (1 + percentage as decimal), such as =100*1.15 to add 15% to 100.
  • Convert percentages to decimals by dividing by 100, so 15% becomes 0.15, 8% becomes 0.08, and 200% becomes 2.00.
  • You can reference cells instead of typing numbers directly, so =A1*1.15 will add 15% to whatever value is in cell A1.
  • If the percentage itself is in a cell, use the formula =A1*(1+B1) where A1 holds the amount and B1 holds the percentage as a decimal.

Using cell references instead of fixed numbers

In a real spreadsheet, you rarely type the numbers directly into the formula. Instead, you reference the cells where those numbers live. If the amount you want to increase is in cell A1 and you want to add 15%, you write =A1*1.15. The spreadsheet reads the value in A1, multiplies it by 1.15, and shows the result in your current cell.

This matters because it lets you change the original amount later and the result updates automatically. If you had typed =100*1.15 directly, changing the 100 would require editing the formula. Using =A1*1.15 means you only change the value in A1 and everything recalculates.

You can also use cell references for the percentage itself. If the percentage is stored in cell B1 as a decimal (0.15 for 15%), the formula becomes =A1*(1+B1). This is useful when you have many rows of data and the percentage applies to all of them, or when the percentage changes and you want to update it in one place.

Converting percentages to decimals

Spreadsheets do not automatically understand that 15 means 15%. You have to convert the percentage to decimal form yourself. Divide the percentage number by 100: 15% becomes 0.15, 8% becomes 0.08, 200% becomes 2.00, and 0.5% becomes 0.005.

If a cell already contains a percentage formatted as a number (like the cell displays "15%"), the spreadsheet usually stores it as 0.15 behind the scenes. You can test this by writing a formula that references that cell. If the result is correct, the cell was already storing the decimal. If the result is 15 times too large, the cell is storing 15 as a whole number and you need to divide by 100 in your formula: =A1*(1+B1/100).

Working with multiple rows of data

When you have a list of amounts and need to add the same percentage to each one, write the formula once and then copy it down. Put your amounts in column A, starting at A2. In cell B2, write =A2*1.15 to add 15% to the first amount. Then click on B2 and drag the small square at the bottom-right corner of the cell down to B10 (or however many rows you have). The spreadsheet automatically adjusts the cell references, so B3 becomes =A3*1.15, B4 becomes =A4*1.15, and so on.

If the percentage varies by row and is stored in column C, use the formula =A2*(1+C2) in B2 and copy it down the same way. Each row will add its own percentage from column C to its own amount from column A.

Adding tax or markup to a price

A common use is calculating the final price after tax or adding a markup to a cost. If an item costs $50 and tax is 8%, the formula is =50*1.08, which gives $54. If you are a business adding a 40% markup to a product that costs you $20, the formula is =20*1.40, which gives $28 as the selling price.

The same formula works whether you are adding a small percentage like 2% or a large one like 150%. The structure never changes: multiply the base amount by (1 plus the percentage as a decimal).

Checking your work

A quick way to verify your formula is correct: if you are adding 10% to 100, you should get 110. If you are adding 50% to 200, you should get 300. If your result seems way too large or too small, check whether you converted the percentage to a decimal correctly, or whether you accidentally multiplied by the percentage alone instead of by (1 plus the percentage).

Another check: the result should always be larger than the original amount (unless the percentage is negative, which subtracts instead). If your formula produces a number smaller than what you started with, something is backwards.

When you need to subtract a percentage instead

The same logic works in reverse. To subtract a percentage, use 1 minus the percentage as a decimal. Subtracting 15% from 100 uses the formula =100*0.85 (which is 1 minus 0.15). Subtracting 20% from a price uses =price*0.80. This is useful for discounts, reductions, or depreciation.

The key difference: adding uses (1 + decimal), subtracting uses (1 - decimal). Everything else about the formula stays the same.

Frequently Asked Questions

What if the percentage is written as a whole number in the cell, like 15 instead of 0.15?

Divide by 100 in your formula. Use =A1*(1+B1/100) where B1 contains 15. This converts 15 to 0.15 inside the calculation. If you use =A1*(1+B1) with a whole number, you will get a result 100 times too large.

Can I add different percentages to different rows?

Yes. Put each percentage in its own row in a separate column, then use =A2*(1+C2) where A2 is the amount and C2 is the percentage for that row. Copy the formula down and each row will use its own percentage.

How do I add a percentage to a total that already includes other calculations?

The formula works the same way. If cell D5 contains a subtotal, use =D5*1.15 to add 15% to it. The spreadsheet does not care whether D5 is a typed number or the result of another formula.

What is the difference between adding 15% and multiplying by 1.15?

They are the same thing. Multiplying by 1.15 is the mathematical way to add 15%. Multiplying by just 0.15 would give you only 15% of the original, not the original plus 15%.

Can I format the result as a currency or percentage?

Yes, but format it as currency if it represents money, and as a number if it represents a percentage. Right-click the cell, choose Format Cells, and pick the format you want. The formula itself does not change — only how the result displays.