How to Add a Percentage to a Number in Excel

Whether you're calculating a price increase, applying a tax rate, or projecting growth figures, adding a percentage to a number is one of the most common tasks in Excel. The good news: there are several ways to do it, and each approach suits different workflows and skill levels.

What "Adding a Percentage" Actually Means

Before writing any formula, it helps to be clear about what's happening mathematically. When you add, say, 15% to a number, you're not just tacking on 15 — you're calculating 15% of that number and then adding the result to the original.

So: Original Number + (Original Number × Percentage) = Result

Or simplified: Original Number × (1 + Percentage)

For example, adding 15% to 200 gives you: 200 × 1.15 = 230

Excel handles both forms, but understanding this distinction saves a lot of formula confusion.

Method 1: Direct Formula in a Single Cell

The simplest approach — type the number and the percentage directly into a formula.

Formula:

=200*1.15 

Or if your percentage is 15%:

=200*(1+15%) 

Excel recognizes the % symbol natively, so 15% is read as 0.15 automatically. This method works well for quick, one-off calculations where you don't need dynamic references.

Method 2: Reference Cells for the Number and Percentage 📊

For spreadsheets where your values live in separate cells — which is most real-world use — cell references make your formulas flexible and easy to update.

Setup:

• Cell A2: Your base number (e.g., 500)
• Cell B2: Your percentage (e.g., 10% or 0.10)
• Cell C2: Your formula

Formula in C2:

=A2*(1+B2) 

If your percentage is stored as a whole number (like 10 instead of 10%), adjust accordingly:

=A2*(1+B2/100) 

This is the version most useful for budgets, pricing tables, and financial models — because changing the value in A2 or B2 instantly updates the result.

Method 3: Using Paste Special to Add a Percentage In Place

Sometimes you want to modify a column of existing numbers without adding new formula columns. Excel's Paste Special feature handles this.

Steps:

1. Type your multiplier in an empty cell — for a 20% increase, enter 1.2
2. Copy that cell (Ctrl+C)
3. Select the range of numbers you want to modify
4. Right-click → Paste Special
5. Under Operation, choose Multiply
6. Click OK

Excel multiplies each selected value by 1.2, updating the numbers directly. ⚠️ This overwrites your original values, so use it intentionally — or on a copy of your data.

Method 4: Adding a Fixed Percentage Across an Entire Column

When you're applying the same percentage rate to many rows — like a uniform 8% tax — anchoring the percentage cell with an absolute reference keeps your formula consistent as you drag it down.

Formula:

=A2*(1+$B$1) 

The $ signs lock cell B1 so it doesn't shift when you copy the formula to A3, A4, A5, and so on. The base number reference (A2) remains relative and updates with each row.

How Percentage Formatting Affects Your Results

One of the most common sources of confusion: how the percentage is stored in the cell.

If your results look wildly off — like getting 1,500 instead of 115 — this formatting mismatch is almost always the reason. Check the cell format before assuming your formula is wrong.

When the Formula Needs to Go Further

Adding a percentage is often a stepping stone to more complex calculations. Depending on your use case, you might find yourself building on this with:

• IF statements — to apply different percentages based on a threshold
• VLOOKUP or XLOOKUP — to pull the right percentage from a reference table
• Named Ranges — to make formulas like =Price*(1+TaxRate) more readable across large workbooks

Each of these adds layers of flexibility, but they also add complexity — and whether that trade-off makes sense depends entirely on the scale and structure of your spreadsheet.

The Variables That Change Your Approach

The "right" method isn't universal. A few factors shape which approach fits best:

• How often your values change — static numbers vs. dynamic inputs
• Whether you're working solo or sharing the file — others reading your spreadsheet may need formulas to be more explicit or labeled
• How your percentage is entered — formatted as %, as a decimal, or as a whole number
• Whether you need to preserve the original values — Paste Special modifies in place; cell formulas don't
• Excel version and platform — most of these methods work across Excel versions, but interface details (especially Paste Special) can vary slightly between Windows, Mac, and Excel Online

Someone running a simple personal budget works very differently from someone maintaining a shared pricing tool with dozens of SKUs and variable tax rates. The math is the same — the implementation depends on what's already in your spreadsheet and how it's being used.