To calculate a percentage in Excel, divide the part by the total, then format the result as a percentage. For example, with the part in B2 and the total in C2, enter =B2/C2 in D2; if B2 is 45 and C2 is 180, the result is 25% when D2 is formatted as a percentage.
Set up a simple percentage calculator
A reusable percentage calculator needs a place for the values being compared and a result cell. A basic worksheet could use these headings in row 1: Part, Total, Percentage. Enter the numbers in A2 and B2, then put the calculation in C2. The formula is not tied to a particular set of numbers: change either input and the result recalculates.
With the part in A2 and the total in B2, enter =A2/B2 in C2. For a part of 45 and a total of 180, the formula returns 0.25, which displays as 25% after percentage formatting. If you want to fill the calculator down a list, put each part and total on its own row and copy the formula down. Excel adjusts the row references automatically, so the next row uses A3 and B3.
Keep the two inputs clearly labeled. A percentage is meaningful only in relation to its denominator: 45 out of 180 is 25%, while 45 out of 90 is 50%. That is why a calculator should make the total being used visible rather than displaying a percentage without its context.
Format a cell as a percentage
Excel stores a percentage as a decimal fraction: 25% is stored as 0.25. The division formula above produces that decimal, and percentage formatting changes how it is displayed. Select the result cell, then choose Home > Number > Percent Style on Excel for Microsoft 365 for Windows. The Percent Style button displays a percent sign. In Excel for Mac, select the cell and use Home > Percent Style; Excel for the web also offers Percent Style on the Home tab.
On Windows, Ctrl+Shift+% applies percentage formatting to the selected cells. The displayed number of decimal places can be adjusted with the Increase Decimal or Decrease Decimal buttons in the Number group on the Home tab. For example, a result of 0.25625 displays as 26% with no decimal places, or 25.63% with two. Formatting changes the display, not the underlying value.
A frequent mistake is multiplying by 100 and then applying percentage formatting. With the part in A2 and total in B2, =A2/B2 followed by percentage formatting is sufficient. If the formula is instead =A2/B2*100, its result is 25, and percentage formatting displays 2500%. Multiply by 100 only when you deliberately need the numeric value 25 rather than the percentage display 25%.
Calculate a percentage of a number
Sometimes the question is not what share one value represents, but how much a stated percentage of a value is. This is useful for estimating a discount amount, a sales commission, or a tax amount in an illustrative worksheet. Enter the rate as a percentage in its own cell, such as 15%, rather than typing it as 15 if the formula is designed to use a percentage-formatted rate.
With the original amount in A2 and the rate in B2, enter =A2*B2 in C2. If A2 is 240 and B2 is 15%, the result is 36. To show that result as currency, format C2 as currency; do not format it as a percentage, because it is an amount, not a rate. For an actual purchase, tax, or commission, verify the applicable terms and rules separately; this spreadsheet example is arithmetic, not financial or tax advice.
If you need the amount after a discount rather than the discount itself, calculate the remaining share. With the original amount in A2 and the discount rate in B2, enter =A2*(1-B2) in C2. For 240 and 15%, C2 is 204. The discount amount is 36, while the price after the discount is 204; these are different answers to related questions.
Calculate a percentage increase or decrease
To increase an amount by a percentage, multiply it by one plus the rate. With the starting value in A2 and the increase rate in B2, enter =A2*(1+B2) in C2. If A2 is 80 and B2 is 12.5%, the result is 90. This method keeps the original amount and the increase rate separate, making assumptions easy to update.
For a decrease, subtract the rate from one. With the starting value in A2 and the decrease rate in B2, enter =A2*(1-B2) in C2. If A2 is 80 and B2 is 12.5%, the result is 70. These formulas calculate the new value. If you need only the size of the increase or decrease, calculate the rate times the original amount instead.
Check which value the percentage applies to. A 20% increase followed by a 20% decrease does not return to the original amount: starting at 100, a 20% increase gives 120, and a 20% decrease from 120 gives 96. The second change is calculated from the new amount, not the original one. This compounding effect matters in repeated price changes and other sequential calculations.
Find the percentage change between two values
Percentage change compares a new value with an old value. Subtract the old value from the new value, then divide the difference by the old value. A positive result indicates an increase; a negative result indicates a decrease. The old value is the baseline, so swapping the two inputs changes the meaning and usually changes the result.
With the old value in A2 and the new value in B2, enter =(B2-A2)/A2 in C2. If the old value is 80 and the new value is 92, the difference is 12 and the percentage change is 12 divided by 80, or 15%. Format C2 as a percentage to display 15%. If the new value is 68 instead, the calculation is -12 divided by 80, or -15%, which indicates a decrease.
This is not the same as the percentage that the difference represents of the new value. For example, the increase from 80 to 92 is 15% relative to the old value, but 12 divided by 92 is about 13.04%. For conventional percentage change, use the old value as the denominator. If a report specifies a different baseline, label that choice clearly.
Distinguish percentages from percentage points
When comparing two rates, the difference in percentage points is not the same as the relative percentage change. If a rate rises from 18% to 21%, it rises by 3 percentage points. Relative to the original 18% rate, however, the increase is 3 divided by 18, or about 16.67%. Both statements can be correct, but they answer different questions.
With the old rate in A2 and the new rate in B2, enter =B2-A2 in C2 to get the difference. If A2 is 18% and B2 is 21%, C2 is 3%, which is a difference of 3 percentage points. With the same inputs, enter =(B2-A2)/A2 in D2 to find the relative change; D2 is about 16.67% when displayed with two decimal places. State whether you mean percentage points or relative percent change in any report or chart.
Find a missing part or total
A percentage calculator can also work backward. If you know the part and the percentage, divide the part by the percentage to recover the total. For example, if 36 is 15% of a total, the total is 240. This is a useful check when a worksheet gives an amount and its rate but not the original base.
With the part in A2 and the rate in B2, enter =A2/B2 in C2. If A2 is 36 and B2 is 15%, the result is 240. The rate must be stored as 15%, or 0.15, not the whole number 15. If you are solving for the part instead, multiply the total by the rate, as described earlier.
You can also check what percentage a known part is of a known total: divide the part by the total. These inverse-looking calculations are easy to confuse, so name the input cells and decide which value is unknown before writing a formula. A quick reasonableness check helps: if 36 is 15% of a total, the total must be larger than 36.
Prevent errors and check your results
A percentage formula can return an error if its denominator is zero. A blank input can also make the result misleading, especially in a copied-down calculator. One option is to show a blank result until a nonzero total is entered. With the part in B2 and the total in C2, enter =IF(C2=0,"",B2/C2) in D2. If C2 is zero, D2 remains blank; otherwise it calculates the proportion. Format D2 as a percentage.
A blank display is appropriate when the calculation is not ready, but it can hide missing data. For a report where the user needs to notice a zero denominator, show a message instead. With the part in B2 and total in C2, enter =IF(C2=0,"Enter a nonzero total",B2/C2) in D2. The result cell will contain text when C2 is zero and a numeric proportion otherwise. Avoid replacing every error with zero automatically: zero percent is a real result and may be mistaken for a valid calculation.
- Confirm that the numerator and denominator are in the intended order.
- Check whether a rate was entered as 15% or as 15. If the formula expects a percentage, 15 means fifteen, not fifteen percent.
- Verify that the result cell has the right number format. Percentage formatting affects display; it does not correct a wrong formula.
- Test the formula with simple values, such as 25 out of 100, which should give 25%.
If a result looks 100 times too large, check whether the formula multiplied by 100 and the cell is also formatted as a percentage. If it shows a decimal such as 0.25, the calculation may be correct and only the number format may need changing.
Frequently Asked Questions
What is the Excel formula for calculating a percentage?
Divide the part by the total, then format the result cell as a percentage. For example, if the part is in A2 and the total is in B2, use =A2/B2. The denominator must be the whole or baseline you intend to compare against.
How do I calculate 20% of a number in Excel?
Put the number in A2 and enter 20% in B2, then multiply them with =A2*B2 in C2. For a number of 150, the result is 30. If you need the number after a 20% increase, use a different calculation because that includes the original amount too.
How do I calculate percentage change in Excel?
Put the old value in A2 and the new value in B2, then use =(B2-A2)/A2. Format the result as a percentage. A result above zero is an increase, and a result below zero is a decrease. If the old value is zero, ordinary percentage change is undefined.
Why does Excel show 0.25 instead of 25%?
Excel stores 25% as the decimal 0.25. Select the result cell and apply Percent Style from the Home tab. This changes the display to 25% without changing the underlying value used in calculations.
How do I calculate a percentage when the total is zero?
A part divided by zero has no defined percentage, so Excel reports a division error unless the formula handles the case. Use an IF formula to display a blank or an explanatory message when the total is zero, and make sure that this does not disguise missing or invalid input data.
Related
- Remove Duplicates in Excel by Entire Row: A Safe Guide
- Remove Duplicates in Excel: A Clear Step-by-Step Guide
- Clean Excel Rows: Remove Blanks, Duplicates, and Errors
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- DAX vs Excel Formulas: How They Differ and When to UseDAX and Excel formulas both calculate results, but they work in different places and answer different kinds of…
- AVERAGEIF in Excel: Average Numbers by Text CriteriaYes. In Excel, AVERAGEIF can use a text criterion—such as a department name or status—to select which rows…
- Excel Extract Date from DateTime: Formulas and FixesTo extract the date from an Excel date-time value in cell A2, enter =INT(A2). The formula removes the…
- Filter Cells by Color in Excel: Steps and TipsTo filter cells by color in Excel for Microsoft 365 on Windows, select your data, choose Data >…
- Excel Table Drag Formula: Lock Cell ReferencesTo keep a cell reference fixed when you fill a formula down an Excel table, add dollar signs…
- Excel IFS in Multiple Cells: Apply Logic Across RangesTo use IFS in multiple cells, write the formula for the first row, then copy or fill it…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.