To calculate percentage change in Excel, subtract the old value from the new value, then divide by the old value: =(B2-A2)/A2. If A2 contains the old value and B2 the new one, format the result as a percentage; a positive result means an increase, and a negative result means a decrease.
The Percentage-Change Formula
Percentage change describes how much a value has risen or fallen relative to its starting value. The old value is the baseline, so it belongs in the denominator. The general calculation is (new value minus old value) divided by old value. In Excel, parentheses make the order of operations explicit and help prevent a different calculation from being made.
Assuming the old value is in A2 and the new value is in B2, enter =(B2-A2)/A2 in C2. Excel returns a decimal number: for example, 0.2 represents a 20% increase, while -0.2 represents a 20% decrease. Apply percentage formatting to display that decimal in a familiar form.
The formula works whether the values describe prices, monthly sales, page views, inventory, or another quantity that can be compared over time. The key is to put the earlier or reference value in the old-value position, not simply the smaller value. If the value fell, the new value is smaller and the formula automatically returns a negative result.
How the Calculation Works
The subtraction first finds the absolute difference between the two values. Dividing that difference by the old value scales it according to the starting point. This is why the same absolute increase can represent very different percentage changes: a rise of 10 is substantial when a value starts at 20, but small when it starts at 1,000.
For example, if a weekly total changes from 80 to 100, the difference is 20. Dividing 20 by the starting value of 80 gives 0.25, or a 25% increase. If a total changes from 100 to 80, the difference is -20; dividing by 100 gives -0.20, or a 20% decrease. The direction and size of the result both come from the same formula.
Percentage change is not the same as the difference expressed in percentage points. If a survey result moves from 40% to 50%, the difference is 10 percentage points. The relative percentage change is 25%, because the 10-point rise is one quarter of the original 40%. This distinction matters when comparing rates, margins, or survey shares.
Worked Examples
Suppose a product’s price was $40 last month and is $46 this month. With the old price in A2 and the new price in B2, the formula =(B2-A2)/A2 returns 0.15, which displays as 15%. The increase is $6, and $6 is 15% of the original $40.
For a decrease, suppose a team completed 250 orders in one week and 225 in the next. With 250 in A2 and 225 in B2, the same formula =(B2-A2)/A2 returns -0.1, or -10%. The minus sign indicates the direction; the size of the decline is 10%.
For a larger table, put prior-period values in column A, current-period values in column B, and the percentage-change calculation in column C. For example, row 2 can contain one product or month, with the formula in C2 referring to A2 and B2. Copy the formula down the column to compare each corresponding row. Check that each pair actually represents the same product, location, time interval, or other unit before drawing conclusions.
When comparing different periods, keep the direction of comparison consistent. To compare March with February, February is the old value and March is the new value. Reversing the references changes the answer and the interpretation, even though the two values themselves have not changed.
Enter, Copy, and Format the Formula
In Excel for Microsoft 365 on Windows, select the result cell, type the formula, and press Enter. To apply percentage formatting, select the result cell or range and use Home > Number > Percent Style. The keyboard shortcut is Ctrl+Shift+%; on Mac, use Command+Shift+%. The exact position of the Percent Style button can vary with the ribbon layout, but it is in the Number group on the Home tab.
Percentage formatting changes how Excel displays a value; it does not change the underlying calculation. A stored result of 0.15 appears as 15% when formatted as a percentage. If you type 15 into a cell and apply percentage formatting, Excel displays 1500%, because 15 is fifteen whole units rather than the decimal 0.15.
Choose the number of decimal places based on the precision readers need. You can use Increase Decimal or Decrease Decimal in Home > Number to adjust the display. For example, a result might display as 12.5% rather than 13%. The displayed rounding does not necessarily change the stored value, so later calculations can still use the more precise result.
To copy a formula down, select its cell and drag the fill handle at the lower-right corner, or double-click the fill handle when adjacent rows contain data. Excel adjusts relative references as the formula moves. A formula referring to A2 and B2 in row 2 will refer to A3 and B3 in row 3. For separated data, copy and paste into the required cells and verify the references.
Increases, Decreases, and Absolute Change
The percentage-change result is signed: a positive value indicates growth and a negative value indicates a decline. Keep that sign when the direction is meaningful, such as reporting that costs fell or that demand increased. A negative answer is not an Excel error; it is often the most useful part of the result.
Absolute change answers a different question: how many units did the value gain or lose? With the old value in A2 and the new value in B2, enter =B2-A2. If the values are 80 and 100, the absolute change is 20, while the percentage change is 25%. Reports often include both because one conveys scale in units and the other makes comparisons across differently sized values easier.
Some readers ask for the percentage decrease as a positive number. You can describe a decline as 10% by reporting the magnitude, but make the convention clear. If you deliberately need a positive magnitude regardless of direction, use ABS around the calculation. With the old value in A2 and the new value in B2, the formula is =ABS((B2-A2)/A2). This discards the direction, so do not use it when distinguishing increases from decreases matters.
Zero and Negative Starting Values
A zero starting value creates a special case. Percentage change divides by the old value, and division by zero is undefined. If a count moves from zero to five, it is accurate to say the count increased by five, but there is no finite percentage increase relative to zero. Excel will show a division-by-zero error for the basic formula. Do not call this an increase of 100%: that would misrepresent the calculation.
If zero baselines are expected, decide how your report should label them. For example, you may show “N/A” and explain that a percentage cannot be calculated from a zero baseline. With the old value in A2 and the new value in B2, use =IF(A2=0,"N/A",(B2-A2)/A2). This returns text for a zero baseline and a numeric percentage otherwise. Format the result column as Percentage; the text label remains text.
Negative starting values also require care. The formula still calculates mathematically, but a negative denominator can produce a sign that does not match the everyday meaning of “increase” or “decrease.” This can occur with losses, temperatures below zero, or balances below zero. Before interpreting the result, check whether percentage change is a meaningful measure for that subject. For data that crosses zero, it may be clearer to report the absolute difference and explain the movement directly.
Common Errors and Checks
A frequent mistake is dividing by the new value rather than the old one. That changes the question and gives a different percentage. Another is reversing the old and new references, which flips the sign and changes the denominator. Label the columns clearly, for example “Prior month” and “Current month,” and check that the formula uses them in that order.
- Check for blanks: A blank in a source cell may be treated as zero in arithmetic. Confirm that missing data really should count as zero before accepting the result.
- Check units: Comparing dollars with cents, or a monthly figure with an annual figure, can produce a valid calculation that is not a useful comparison.
- Check the baseline: A very small old value can produce an unusually large percentage change. Include the actual values or the absolute difference so readers can judge the scale.
- Check formatting: A decimal such as 0.08 is 8%, not 0.08%, when displayed with Percentage formatting.
- Check the population: A change in a total may reflect changed coverage, missing records, or a different group, not just a change in the underlying performance.
If a result shows an error, inspect the old-value cell first for zero, a formula returning an empty string, or unexpected text. Also verify that the formula was entered as a formula beginning with an equals sign, and not as text because the cell was formatted as Text. If Excel displays the formula itself instead of its result, change the cell format to General and re-enter the formula.
Percentage Change Compared With Other Measures
Percentage change is useful for comparing relative movements, but it does not tell the whole story. A 50% rise from 2 to 3 is a change of only one unit; a 5% rise from 10,000 to 10,500 is a change of 500 units. Whether the relative or absolute movement matters more depends on the decision being made.
It is also not generally reversible by changing the sign. A move from 100 to 150 is a 50% increase. A return from 150 to 100 is a decrease of 33.3% (approximately), because the second calculation uses 150 as its baseline. The endpoints are reversed, but the starting values differ. This is why percentage increases and decreases of the same stated size do not necessarily cancel each other out.
For several periods, calculate each period’s change against the immediately preceding period if the goal is to show period-by-period movement. If the question is instead how far the latest value is from the first period, compare the latest value directly with the first. Those methods answer different questions, so title the result clearly, such as “Change from previous month” or “Change since January.”
Frequently Asked Questions
What is the Excel formula for percentage change?
With the old value in A2 and the new value in B2, use =(B2-A2)/A2. Format the result as a percentage to display it in percent form.
How do I calculate percentage increase in Excel?
Use the same formula, placing the earlier value as the old value and the later, larger value as the new value. A positive result is the percentage increase.
How do I calculate percentage decrease in Excel?
Use the same old-to-new formula. If the new value is lower, Excel returns a negative percentage; the magnitude of that negative result is the percentage decrease.
How do I calculate percentage change when the original value is zero?
A percentage change from zero is undefined because the formula divides by zero. Report the absolute difference or use a clearly explained label such as N/A rather than inventing a percentage.
Why does Excel show a decimal instead of a percent?
The formula returns a decimal ratio, such as 0.15 for 15%. Apply Percentage formatting using Home > Number > Percent Style, or the relevant keyboard shortcut, to display it as a percent.
Related
- Excel Format Numbers in Thousands (K)
- Excel Format Cells Shortcut: Quick Keys for Windows and Mac
- Excel Format as Number: Steps and Common Fixes
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Find Duplicate Entries in Excel with FormulasTo find duplicate entries in Excel, select the cells you want to check and choose Home > Conditional…
- IFS Excel Formula Examples: Syntax, Rules, and TipsExcel’s IFS function checks conditions in order and returns the value linked to the first condition that is…
- Excel Date Filter Multiple Criteria: Practical MethodsTo filter dates in Excel by multiple criteria, turn on AutoFilter, open the date column’s dropdown, and choose…
- Conditional Formatting Dates in Excel: Rules and FormulasTo conditionally format dates in Excel for Microsoft 365 on Windows, select the date cells and choose Home…
- Sort an Excel Column Highest to Lowest: Quick StepsTo sort numbers in Excel from highest to lowest, select a cell in the column and choose Data…
- Excel MID Cell Reference: Extract Text from a CellTo extract characters from a cell in Excel, use the MID function with that cell as its first…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.