How to Add a Percentage to a Number: Methods, Formulas, and When Each Applies

Adding a percentage to a number sounds straightforward — and often it is. But depending on where you're doing the calculation (a spreadsheet, a calculator app, a programming script, or mental math), the method changes. Understanding the underlying logic first makes every tool easier to use correctly.

What "Adding a Percentage" Actually Means

When someone says "add 20% to 150," they mean: calculate 20% of 150, then add that result to the original number.

The core formula is:

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

So for 150 + 20%:

• 20 ÷ 100 = 0.20
• 1 + 0.20 = 1.20
• 150 × 1.20 = 180

This single multiplier approach (multiplying by 1.20 instead of calculating 20% separately and adding) is faster and less error-prone, especially in spreadsheets and code.

The Two-Step vs. One-Step Method

Both approaches produce the same result. The difference is clarity vs. efficiency.

Two-step example (adding 15% to 200):

1. 200 × 0.15 = 30
2. 200 + 30 = 230

One-step example:

1. 200 × 1.15 = 230

Both are correct. The one-step version is preferred when building formulas because it reduces cell references and potential input errors.

How to Add a Percentage in a Spreadsheet 📊

In Excel or Google Sheets, the formula depends on where your values are stored.

If the number is in A1 and the percentage is in B1:

This assumes B1 is already formatted as a percentage (e.g., displays as 20%). If B1 contains a raw number like 20 (not 20%), use:

Common mistakes to watch for:

• Mixing percentage-formatted cells with raw number cells causes doubled or halved results
• Forgetting to lock cell references with $ when copying formulas down a column
• Using =A1+B1% which works in some contexts but behaves inconsistently across versions

The format of your percentage cell matters more than most users expect. Right-click the cell, check its format, and confirm whether it stores 0.20 or 20 before building the formula.

How to Add a Percentage on a Basic Calculator

Most physical and mobile calculators handle this differently depending on the model.

Method 1 (most calculators):

• Enter the original number (e.g., 150)
• Press +
• Enter the percentage value (e.g., 20)
• Press %
• Press =

This works on most standard calculators. The % key converts 20 into 0.20 and completes the addition in one step.

Method 2 (if your calculator lacks a % key or behaves unexpectedly):

• Calculate manually: 150 × 1.20 = 180

Scientific calculators and some mobile calculator apps treat the % key differently — some apply it relative to the last number entered, others apply it as a straight division by 100. If you're getting unexpected results, the manual multiplier method is the reliable fallback.

Adding Percentages in Code or Scripting Environments

In any programming language, the logic is the same — but syntax varies.

Python: