Excel percentage points versus percentage change

A rate rising from 20% to 25% increases by five percentage points and by 25% relative to its previous value. These are different descriptions of the same change. Label the unit explicitly so readers do not confuse an absolute rate difference with relative growth.

Percentage points are useful for describing the distance between rates. Relative percentage change describes that distance compared with the baseline. Neither alone explains whether the underlying business outcome improved for a comparable population.

Build the two calculations

Enter 20% in B2 and 25% in C2. Excel stores these as 0.20 and 0.25. Use:

=(C2-B2)*100

The result is 5. Format it as a number and label the column Change in percentage points. Do not apply percentage formatting to this already multiplied result, which would display 500%.

For relative change, use:

=(C2-B2)/B2

The result is 0.25. Format this cell as a percentage to display 25%, and label it Relative change. Alternatively, C2/B2-1 gives the same result when the baseline is nonzero.

These formulas are direct arithmetic, not claims about a real campaign. The expected values can be checked by hand: 25−20=5 and 5/20=0.25.

Keep counts beside the rates

Suppose the first period has 20 conversions among 100 eligible visits, while the second has 25 among 100. The change is easy to inspect because both denominators are equal.

Now suppose the second period has 10 conversions among 40 visits. The rate is still 25%, but the number of conversions fell from 20 to 10. A report showing only “conversion rate up 25%” conceals that different business outcome.

Keep numerator, denominator, rate, percentage-point difference and relative change together when the decision needs that context. Confirm that eligibility, tracking and observation windows are comparable across periods.

Do not average subgroup percentages blindly

If one segment has 1 conversion from 10 visits and another has 90 from 100, the unweighted average of 10% and 90% is 50%. The pooled rate is 91/110, approximately 82.73%.

Calculate the overall rate from summed eligible numerators and denominators. A shift in segment mix can change the overall rate even when every segment's own rate stays constant. Inspect comparable subgroup results before attributing the overall change to an intervention.

The weighted-average lesson develops the same denominator principle with price and discount examples.

Handle a zero baseline transparently

From 0% to 5%, the absolute increase is five percentage points. Relative percentage change under the usual difference-divided-by-baseline formula is undefined because the denominator is zero.

Use an explicit status rather than presenting 0% growth:

=IF(B2=0,"Relative change undefined",(C2-B2)/B2)

This example assumes B2 is a known numeric rate. Validate missing or invalid inputs separately so a blank cell is not mistaken for a confirmed zero baseline.

Broadly wrapping every calculation in IFERROR can also hide broken references or text errors. Microsoft's IFERROR documentation shows that the function handles multiple error types; an expected zero-denominator case deserves a specific explanation.

Choose language that matches the decision

“Rate increased from 20% to 25%, up five percentage points” is usually easy to interpret. Add “25% relative increase” when the relative scale matters. Include period labels and counts so readers can assess the size of the underlying population.

A decline from 25% to 20% is −5 percentage points but −20% relative change. Relative changes are asymmetric because their denominators differ. A 25% increase followed by a 20% decrease returns this example to its starting rate.

These descriptive calculations do not establish statistical reliability or causation. Small samples, different populations and measurement changes require further analysis before a business conclusion.

Exercise: calculate both changes for 2% to 3%, 50% to 45% and 0% to 2%. Write a one-sentence report for each that cannot be mistaken for the other change measure.

NeuraPath's Data Analytics with Generative AI course connects spreadsheet calculation with clear business communication. Correct labels and visible denominators make a percentage report materially more useful.

Continue learning

This article is part of the Excel and spreadsheet quality sequence. Use the neighbouring tasks when you need the prerequisite or the next application.

• Review the prerequisite or neighbouring task in Reconcile two Excel lists with unmatched-record reports.
• Continue with Build a refreshable expense-category mapping table.