How to Add a Percentage to a Number in Excel

Adding a percentage to a number in Excel is one of those tasks that looks simple but hides a few important decisions. Whether you're calculating a price increase, applying a tax rate, or projecting growth, the method you use — and how you set up your spreadsheet — changes what you get. Here's how it actually works.

What "Adding a Percentage" Actually Means

Before touching a formula, it's worth being precise about the math. When most people say "add 10% to a number," they mean:

Result = Original Number × (1 + Percentage)

So adding 10% to 200 gives you 200 × 1.10 = 220.

This is different from simply calculating 10% of 200 (which is 20) and stopping there. Excel can do both, but they're separate operations with different formulas.

The Core Formula Methods

Method 1: Multiply by (1 + Percent) Directly

If your original number is in cell A2 and you want to add 15% to it:

This works fine for a one-off calculation. The percentage is hardcoded into the formula, which is fast but inflexible if you need to adjust the rate later.

Method 2: Reference a Separate Percentage Cell

A more practical approach stores the percentage in its own cell — say, B2 — and references it:

For this to work correctly, B2 must be formatted as a percentage in Excel. If you type 15 into B2 and format it as a percentage, Excel stores it as 0.15 internally. If B2 contains the raw decimal 0.15 without percentage formatting, the formula works the same way — the formatting is cosmetic. The confusion happens when someone types 15 and Excel stores it as 15, not 0.15. In that case, you'd need:

Getting this distinction wrong is the most common source of incorrect results when adding percentages in Excel.

Method 3: Add the Percentage Amount Separately

Some workflows benefit from showing the percentage increase as its own column:

This is equivalent to =A2*(1+B2) but makes the intermediate step visible — useful for invoices, budgets, or any document where the reader needs to see the markup amount explicitly.

Applying a Percentage Increase to an Entire Column 📊

If you have a list of values in column A and want to add the same percentage to all of them, you have two clean options:

Option 1 — Formula column: Put your formula in column B (e.g., =A2*(1+0.15)) and drag it down. Original data stays untouched.

Option 2 — Paste Special (in-place modification):

1. Type your multiplier (e.g., 1.15) in an empty cell
2. Copy that cell
3. Select your range of original values
4. Go to Paste Special → Multiply
5. Delete the helper cell

This overwrites the original values with the increased ones — no extra column needed. Use this method carefully; it's not easily reversible without Ctrl+Z.

Formatting Matters More Than You Might Expect

Excel treats the number 0.15 and a cell displaying 15% as the same value internally, but how you enter data and how cells are formatted changes what formulas receive. A few practical rules:

• If you type a number directly into a formula, use the decimal form: 0.15 for 15%
• If you're referencing a cell, check whether that cell is formatted as Percentage or General/Number before deciding whether to divide by 100
• If results look off by a factor of 100, a formatting mismatch is almost certainly the cause

Variables That Affect Which Approach Works Best for You

The "right" method depends on factors specific to your spreadsheet:

• How often the percentage changes — A hardcoded formula is fine for one-time calculations; a referenced cell is better when the rate is a variable input
• Whether you need to preserve original values — Formula columns protect originals; Paste Special modifies them in place
• Who else uses the file — If others will edit it, a clearly labeled percentage input cell with a referenced formula is far easier to maintain than hunting through formulas for hardcoded numbers
• How many rows are involved — For large datasets, array formulas or table-structured references (using Excel Tables with structured references like [@Price]*(1+[@Rate])) scale more cleanly than dragging individual formulas
• Your Excel version — Dynamic array functions available in Excel 365 and Excel 2019+ offer additional flexibility for working with ranges, though the basic multiplication approach works across all modern versions

When Results Don't Look Right 🔍

A few things to check if your percentage addition isn't working as expected:

• Cell formatted as Text — If a cell is formatted as Text, Excel won't calculate it. Reformat as General or Number and re-enter the value.
• Percentage entered as a whole number — 15 in a non-percentage-formatted cell is not the same as 15%. Always verify what's actually stored using the formula bar.
• Circular references — If your formula accidentally references the cell it's calculating into, Excel will flag an error or return zero.

Different Use Cases, Different Setups

A freelancer adding a 20% markup to project costs needs a different setup than a finance analyst applying variable tax rates to thousands of invoice lines. The freelancer might be fine with a single formula per row. The analyst likely needs a structured Excel Table, a dedicated rate input cell with a named range, and possibly conditional logic for different tax tiers.

The math is the same. The spreadsheet architecture that makes it reliable, maintainable, and error-resistant depends entirely on how the file will be used, by whom, and how frequently the inputs change. That's the part no universal formula can answer.