What is the Excel formula for X percent of a number?

Type =number*percent into a cell. For example, =200*15% returns 30 because Excel applies (15 ÷ 100) × 200. You can also write the percentage as a decimal, such as =200*0.15, with the same result. The Percentage Calculator's X% of Y mode accepts the same two inputs and shows the worked equation beside the answer.

How do I calculate a test score percentage in Excel?

Divide the score by the total and format the cell as a percentage. For 42 out of 50, enter =42/50, which gives 0.84, then press Ctrl+Shift+% (or use the % button on the Home tab) to display it as 84%. The same pattern handles completion rates, market share, and budget-spent calculations.

What is the formula for percentage increase or decrease in Excel?

Use =(new-old)/old and format as a percentage. From 200 to 250 the formula =(250-200)/200 returns 0.25, formatted as +25%. From 250 back to 200, =(200-250)/250 returns -0.20, formatted as -20%. A positive value is an increase, a negative value is a decrease, and equal values give 0%.

Why is going from 200 to 250 not the same as going from 250 to 200?

Because percentage change is always measured against the starting value, and the two moves have different starting points. A 50-unit rise from 200 is 50 ÷ 200 = +25%, while a 50-unit fall from 250 is 50 ÷ 250 = -20%. The same 50-unit gap is a different share of a different base, so the percentages differ.

What happens if I divide by zero in a percentage formula?

Excel displays the #DIV/0! error. The Percentage Calculator guards the same case and shows a clear message instead of an error code. In both cases the result is undefined, because you cannot express a share of zero or measure change from a starting value of zero.

Can I use negative numbers in Excel percentage formulas?

Yes. -10% of 200 can be written as =200*-10% or =200*(-0.1) and returns -20. For percentage change, a fall can produce a negative result, such as =(180-200)/200 formatted as -10%. The Percentage Calculator accepts negative inputs wherever they make sense and guards division-by-zero at the same time.

How to Calculate Percentage in Excel: 3 Formulas

To calculate a percentage in Excel, multiply a number by the decimal form of the percent for a part-of-whole result, divide a part by the whole to express one number as a share of another, or subtract the old value from the new value and divide by the old value for percentage change. Every percentage question you will ever meet in a spreadsheet reduces to one of those three operations, and the right formula is almost always shorter than the question that prompted it. To work out 15% of 200, you type =200*15% (or =200*0.15) into any cell and Excel returns 30. To express 30 as a percent of 200, you enter =30/200 and format the cell as a percentage so it displays 15%. To measure the change from 200 to 250, you write =(250-200)/200 and apply percentage formatting for a +25% result. Once those three patterns are familiar, almost every business, finance, statistics, or homework scenario that involves percentages becomes a one-line formula. For users who would rather skip the formula step entirely, the Percentage Calculator handles the same three calculations in a browser with the answer and the worked equation shown together.

The Three Percentage Questions Excel Solves

Before you touch any formula, it helps to name the three questions people actually ask about percentages. They map cleanly onto the three problem types Excel handles, and they also map cleanly onto the three modes of the Percentage Calculator, which is why both tools feel interchangeable once you understand them.

X% of Y — what portion of a number does a given percent represent? Think discount amounts, sales tax, tips, commission, or simple interest for a single period.
X is what % of Y — what share of a total does one number represent? Think test scores, completion rates, market share, or how much of a budget has been spent.
% change — how much has a value grown or shrunk between two points? Think price rises, salary bumps, investment returns, traffic growth, weight loss, or any before-and-after comparison.

If you can label the problem you are trying to solve as one of those three, you have already chosen the right formula or the right calculator mode.

How to Find X% of a Number in Excel

This is the most common percentage task and the simplest to write. The Excel formula multiplies the number by the percent, and Excel takes care of converting the percent into its decimal form automatically when you type the % sign.

Click the cell where the answer should appear.
Type = followed by the cell reference (or literal number), then *, then the percentage.
Press Enter. The result is the part-of-whole value with no formatting needed, because the answer is a raw number rather than a percent.

For example, to work out 15% of 200, type =200*15%. Excel applies the formula (X ÷ 100) × Y, so 15% of 200 equals (15 ÷ 100) × 200 = 30. The same approach handles a 20% discount on a $60 jacket (=60*20% returns 12), an 18% tip on a $45 bill (=45*18% returns 8.10), or any tax, commission, or interest calculation against a single base amount. The formula works on any numeric values, so you can just as easily find 15% of 200 as 6.5% of 1,240. If you would rather not write the formula, the Percentage Calculator in X% of Y mode accepts the same two inputs and shows the answer with the worked equation beneath it.

How to Find What Percent One Number Is of Another in Excel

This is the share-of-total question, and it is the formula behind grading a test, calculating a completion rate, or measuring how much of a budget is spent. The pattern is to divide the part by the whole and then apply percentage formatting so the decimal displays as a percent.

Click the cell where the percentage should appear.
Type =, then the cell containing the smaller number (the part), then /, then the cell containing the larger number (the total).
Press Enter. The cell shows a decimal such as 0.84.
Select the cell, press Ctrl+Shift+% (or click the % button on the Home tab) to apply Percentage formatting. The value becomes 84%.

The formula divides the part by the whole and multiplies by 100 behind the scenes, so 42 out of 50 produces 84% and 30 out of 200 produces 15%. If the total is in cell B2 and the part is in A2, the formula becomes =A2/B2. One important Excel rule: the second number (the whole) cannot be zero, because division by zero returns the #DIV/0! error. The Percentage Calculator guards the same edge case in its X is what % of Y mode and shows a clear message instead of an error string.

How to Calculate Percentage Increase or Decrease in Excel

Percentage change is the formula behind every before-and-after comparison, from a price rise to a year-over-year revenue figure. Excel calculates it by dividing the difference between the two values by the starting value.

Click the cell where the percentage should appear.
Type =, then open a parenthesis, then the new value, then -, then the old value, then close the parenthesis, then /, then the old value again.
Press Enter to get a decimal result.
Apply Percentage formatting so the decimal displays as a percent with a + or − sign.

For example, a price that rises from 200 to 250 uses =(250-200)/200, which equals 0.25, formatted as +25%. A price that falls from 250 back to 200 uses =(200-250)/250, which equals -0.20, formatted as -20%. Notice that the two moves are not mirror images: the 50-unit rise is 25% of the smaller starting point of 200, while the 50-unit fall is 20% of the larger starting point of 250. That asymmetry is built into the formula and shows up the same way in the Percentage Calculator's % change mode. A positive result is an increase, a negative result is a decrease, and equal values give 0%. If the starting value is zero, the change is undefined and Excel will display #DIV/0!; the calculator returns a clear message instead of a misleading number.

How to Use the Percentage Calculator

For readers who would rather not type a formula, the Percentage Calculator runs the same three calculations in a browser. Everything happens locally, so nothing is uploaded to a server, and the answer plus the worked equation appear as you type.

Choose a mode: X% of Y to find a percentage of a number, X is what % of Y to turn two numbers into a percent, or % change to compare a before and after value.
Type your two numbers into the fields. The labels update to match the mode you picked, and negative numbers are allowed where they make sense.
Read the answer and the worked formula, which update instantly below as you type — no button to press and nothing sent to a server.

The first mode applies (X ÷ 100) × Y, the second applies X ÷ Y × 100, and the third applies (new − old) ÷ old × 100. Results are rounded for a clean display while staying accurate to full precision, so you never see floating-point noise like 30.000000000004, and the formula is echoed back every time so you can check the working or learn how it was done. Negative numbers are accepted wherever they make sense, so −10% of 200 returns −20, and a fall can produce a negative percentage change. Division by zero is guarded: if the whole is 0 in the what percent mode, or the starting value is 0 in the % change mode, the tool shows a clear message instead of a misleading result.

Excel Formulas vs. an Online Percentage Calculator

Both tools produce the same three answers, but they fit different situations. The table below compares them across the scenarios that matter most for everyday work.

Scenario	Best fit	Why
Working through a column of hundreds of rows in a spreadsheet	Excel	Formulas copy down with the fill handle, so one pattern covers every row automatically.
One-off answer outside of a spreadsheet (shopping, tipping, grading)	Percentage Calculator	No formula to remember, no formatting to apply, and the worked equation is shown beside the result.
Sharing a calculation with someone who does not use Excel	Percentage Calculator	Anyone with a browser can paste in two numbers and read the answer immediately.
Documenting a reusable calculation that will be audited later	Excel	The formula is right in the cell, so the working is transparent and editable without leaving the workbook.
Dealing with negative numbers, mixed signs, or zero starting values	Percentage Calculator	The tool guards division-by-zero and accepts negatives wherever they make sense, with a clear message instead of an error code.
Doing homework or studying how the formula is built	Either	The calculator echoes the formula on screen, and Excel shows the formula bar, so both reinforce the same underlying math.

In practice, the two tools complement each other. Build reusable models in Excel so the working stays transparent and scales across thousands of rows, and switch to the Percentage Calculator for quick answers, edge cases, and any time you would rather read the result than type the formula. Either way, the three patterns above — X% of Y, share of total, and percent change — cover every percentage calculation most people ever need.