FormulasFree · No signup

Excel Percentage Calculator

Pick the question you are actually asking — 15% of a number, the change from last month, or one product's share of sales — and get the answer plus the formula that reproduces it.

Runs in your browserUpdated October 29, 2026Four percentage modes · Formula for each · Percentage-point warning

The short answer

An Excel percentage calculator turns the question into the right formula: =A2*B2% for a percentage of a number, =(B2-A2)/A2 for percent change, =A2/B2 for a share of a total, and =A2*(1+B2%) for an increase. The result is formatted as a percentage, and percentage points are kept separate from percent change.

NumberThe value you want a percentage of.Percentage (%)For example 15 means 15%.

Answer

Decimal form

Remainder

204

=A2*B2%

Format the result as Currency, Number or General — not Percentage — or Excel will multiply it by 100 for display.

B2% converts 15% to 0.15 and multiplies it by 240. If your percentage is stored as a whole number (15 rather than 0.15), the formula is =A2*B2/100.

Put the first value in A2 and the second in B2, then replace the references above.

Percentage formulas in Excel

Question	Formula
What is 15% of 240?	=240*15% → 36
What percent is 45 of 180?	=45/180 → 25%
What is the change from 200 to 250?	=(250-200)/200 → 25%
Increase 240 by 15%	=240*(1+15%) → 276
Decrease 240 by 15%	=240*(1-15%) → 204
Each row's share of a column total	=A2/SUM($A$2:$A$10)

Formatting the cell as Percentage is the last step — the formula itself should stay a plain division.

Check the formula

How to use it

1Choose the question: percentage of a number, percent change, increase/decrease or share of a total.
2Enter the two values from your sheet — the order matters for percent change and share.
3Read the answer, then check whether you need percent change or percentage points.
4Copy the Excel formula and replace A2/B2 with your real cell references.

Questions about the percentage calculator

How do I calculate a percentage in Excel?

Divide the part by the whole: =A2/B2, then format the cell as Percentage (Ctrl+Shift+%). If you need a plain number, multiply by 100 or use =A2/B2*100. For 45 out of 60, =45/60 returns 75%.

What is the difference between percent change and percentage points?

Moving from 5% to 6% is an increase of 1 percentage point but a 20% change, because (6−5)/5 = 0.20. Use percentage points when comparing two percentages directly, and percent change when comparing the size of the move.

Why does Excel show 0.15 instead of 15%?

The cell is formatted as General or Number. Select it and press Ctrl+Shift+% (Cmd+Shift+% on Mac), or use Format Cells → Percentage. The underlying value stays 0.15; only the display changes.

How do I calculate each row's percentage of a total?

Divide each value by an absolute total: =A2/SUM($A$2:$A$10). The dollar signs lock the total range so the formula copies down correctly. Format the result as a percentage.

Need it done for you?

Percentage question turning into a marks problem?

Send the workbook and the brief. We fix the formulas, add the percentage formatting and explain each step so you can defend it in class.

Get a fixed quote Ask on WhatsApp See pricing →

From $15/hr
Fixed quote before work starts
Free minor revisions
Human experts, not AI files

Related free tools

All tools →

Formula ExplainerPaste any Excel formula and get a plain-English explanation of every function, range and nested step.Open tool →Formula CheckerCheck any Excel formula for syntax errors, wrong argument counts, approximate-match traps and #REF! errors.Open tool →Formula GeneratorBuild accurate Excel formulas from plain choices: SUMIF, SUMIFS, COUNTIF, IF, IFERROR, TEXTJOIN, INDEX MATCH and more.Open tool →

Keep reading

Question

Formula

What is 15% of 240?

=240*15% → 36

What percent is 45 of 180?

=45/180 → 25%

What is the change from 200 to 250?

=(250-200)/200 → 25%

Increase 240 by 15%

=240*(1+15%) → 276

Decrease 240 by 15%

=240*(1-15%) → 204

Each row's share of a column total

=A2/SUM($A$2:$A$10)

How to use it

1Choose the question: percentage of a number, percent change, increase/decrease or share of a total.

2Enter the two values from your sheet — the order matters for percent change and share.

3Read the answer, then check whether you need percent change or percentage points.

4Copy the Excel formula and replace A2/B2 with your real cell references.