How to Add a Percentage to a Number: A Complete Guide

Adding a percentage to a number is one of those calculations that comes up constantly — whether you're figuring out a tip, calculating tax on a purchase, applying a markup to a price, or working with data in a spreadsheet. The math itself is straightforward, but the method you use depends on your context, tool, and what you're actually trying to accomplish.

What Does "Adding a Percentage" Actually Mean?

When you add a percentage to a number, you're increasing that number by a proportional amount. The percentage represents a fraction of the original value, and you're adding that fraction back onto the base number.

For example: adding 20% to 50 doesn't mean adding 20 to 50. It means adding 20% of 50 (which is 10) to 50 — giving you 60.

This distinction matters. A percentage is always relative to the base number, not a fixed value.

The Core Formula

The universal formula for adding a percentage to a number is:

Result = Original Number × (1 + Percentage ÷ 100)

Breaking that down:

• Divide the percentage by 100 to convert it to a decimal
• Add 1 to that decimal (the "1" represents keeping the original value intact)
• Multiply by your original number

Example: Add 15% to 200 → 200 × (1 + 15 ÷ 100) → 200 × 1.15 → 230

This single formula works in almost every tool and context — calculators, spreadsheets, programming languages, and mental math.

How to Do It in Common Tools

🖩 Basic Calculator

Most calculators handle this in two steps:

1. Multiply your number by the percentage (e.g., 200 × 15 = 3,000... then ÷ 100 = 30)
2. Add the result to the original number (200 + 30 = 230)

Some physical calculators have a dedicated % key that shortens this. Entering 200 + 15 % on those models applies the percentage automatically — but behavior varies by calculator model, so it's worth testing with a known value first.

📊 Microsoft Excel and Google Sheets

Spreadsheets are where this calculation gets genuinely powerful, especially when applied across large datasets.

Basic formula in a cell: =A1*(1+B1)

Where A1 contains your original number and B1 contains the percentage value (formatted as a percentage or as a decimal).

Important formatting note: If cell B1 is formatted as a percentage (e.g., displays "15%"), Excel and Google Sheets store it internally as 0.15. Your formula =A1*(1+B1) works correctly as written.

If B1 contains a plain number like "15" (not formatted as a percentage), adjust your formula: =A1*(1+B1/100)

Getting this wrong is one of the most common spreadsheet errors when working with percentage-based calculations.

Python and Other Programming Contexts

In code, the logic mirrors the formula directly: