Percentage change calculation: formula, examples and difference

Why the initial value is the denominator

A price moving from 50 to 60 adds 10 to a base of 50, so the increase is 20%. Reversing the path, from 60 to 50, gives a 16.67% decrease because the base is now 60.

This asymmetry is expected, not a formula error. In a report, state which period or measurement is the reference, especially when comparing sales, users, energy use or indicators with different scales.

• Write Vi first and Vf second; do not reorder values just because one is smaller.
• Check that units match: dollars with dollars, kilograms with kilograms, visits with visits.
• Name the period: month over month, year over year, or before and after a change.

Worked examples between two numbers

A growth example makes every step visible. If a shop moves from 240 to 300 orders, the difference is 60. Dividing 60 by 240 gives 0.25, so the final number is 25% higher than the baseline.

For a decrease, consider energy use falling from 500 to 425 kWh. The difference is −75 and −75 / 500 × 100 = −15%. Writing −15% is more precise than saying only “15% less” because it preserves direction.

Percentage change versus percentage difference

In everyday language, percentage difference can mean two things. When there is a timeline or a clear baseline, use percentage change with the absolute value of the first number in the denominator. It fits growth, decline, budget variance and year-over-year reporting.

When two values are compared without choosing a reference, a symmetric difference can divide the absolute difference by the average of the absolute values. This measure does not identify a baseline, so describe it clearly in the report.

Zero, negative values and extreme results

When the initial value is zero, division by zero is undefined. You can still report the absolute difference, or describe the move as “from zero to 30 units” without turning it into a made-up percentage.

With a negative baseline, the denominator stays positive because the formula uses its absolute value. From −100 to −80, the difference is +20 and the change is +20% on a base of 100: the number rises even though it remains below zero. When values cross zero or represent accounting losses, show the original values and explain the convention.

• Do not replace a zero baseline with 1 just to obtain a percentage.
• For very small bases, show precision and the measurement unit.
• If a negative sign has accounting meaning, add a sentence that explains the result.

Percentage change calculation in Excel and Sheets

Put the initial value in B2 and the final value in C2. Enter `=(C2-B2)/ABS(B2)` in another cell and format it as Percentage. The move from 80 to 100 displays as 25%; do not multiply by 100 when the cell already uses percentage formatting.

To avoid division by zero when B2 is zero, use a condition such as `=IF(B2=0,"n/a",(C2-B2)/ABS(B2))`. Function names and argument separators vary with spreadsheet language and settings.

1. Enter the baselineType the initial value in B2 and confirm the unit.
2. Enter the resultType the final value in C2 using the same scale.
3. Apply the formulaUse `(C2-B2)/ABS(B2)`, then format the cell as Percentage.

A four-step validation routine

When the calculation enters a quote or report, the formula is only part of the job. A short review prevents comparisons between unmatched periods, prices with different tax treatment, or quantities collected under changed rules.

Keep the original values beside the rounded result. Readers can then rebuild the calculation and distinguish a real change from rounding, seasonality or a revision to the source data.

1. Define the questionAre you measuring growth, decline, variance or a simple difference?
2. Fix the baselineRecord which value represents before, budget or the reference group.
3. Avoid early roundingKeep extra decimals during division and round the displayed result last.
4. Explain the signState whether the number means an increase, decrease or undefined result.

What the percentage cannot tell you alone

Percentage change describes relative distance, not cause. A 30% rise in visits may come from a campaign, seasonality or a tracking change. Before making a decision, pair the percentage with absolute counts, the time window and a consistent source.

Very large percentages can come from tiny bases. Moving from 1 to 2 is +100%, but it means only one extra unit. Show both values and do not use the percentage alone as proof of an important outcome.

• Report the initial value, final value and absolute difference together.
• Use the same time window and collection rules.
• For tax, financial or accounting decisions, have the surrounding context checked by a professional.