Percentage Points or Percent Change? Check the Starting Value

Updated 24/10/2026 · Reviewed content

A rate moving from 25% to 50% has risen by 25 percentage points and by 100% relative to its starting rate. Both statements can describe the same change, but they answer different questions. Write the starting value and the calculation beside the result before sharing it.

Ask which change the reader needs

A percentage-point difference subtracts one percentage rate from another. A relative percentage change compares the difference with the starting rate. The phrase “up 25%” leaves room for confusion when the writer actually means a change of 25 percentage points.

Start with a sentence describing the question. “How far apart are the two attendance rates?” asks for a point difference. “How much larger is the later rate compared with the earlier one?” asks for a relative change. Neither question by itself asks how many more people attended.

Keep counts and rates together. A rate can rise while the number of people falls if the group being measured becomes smaller. The following invented example makes that distinction visible without relying on a real organisation's records.

Work through a community session example

In this fictional Kuala Lumpur example, Mei keeps a record of two separate community drawing sessions. The first has 40 confirmed places and 10 attendees. The second has 16 confirmed places and 8 attendees. For this exercise, attendance rate means attendees divided by confirmed places; both sessions use that same definition.

The first rate is 10 divided by 40, or 0.25. The second is 8 divided by 16, or 0.50. Their difference is 0.25, equivalent to 25 percentage points. Relative to the first rate, the increase is 0.25 divided by 0.25, or 100%.

The attendee count has gone the other way: 8 minus 10 is a decrease of 2 people. Dividing that change by the starting count of 10 gives a 20% decrease. This does not contradict the rise in attendance rate because the available-place count changed as well.

These figures, the setting and the interpretation exercise are original i8 Live teaching material. They are not Malaysian attendance statistics, a performance claim or a live spreadsheet test.

Put each calculation in its own Excel cell

For a disposable practice sheet, place the two confirmed-place counts in B2 and C2, and the attendee counts in B3 and C3. Enter =B3/B2 in B4 and =C3/C2 in C4. Apply percentage formatting to B4 and C4 so the rates appear as 25% and 50%.

Microsoft documents dividing an amount by its total to calculate a proportion, then displaying the result using percentage formatting. It also documents the relative-change pattern of subtracting the old value from the new value and dividing by the old value. Those limited Excel facts support the formulas here; the session comparison and reporting method are our own analysis.

Keep the rate-difference result as a number with a column label of “percentage points”. Apply percentage formatting to the two relative-change results. Formatting the numeric 25 as a percentage would display 2500%, which would be a different and misleading presentation of this example.

Microsoft's formatting documentation distinguishes the number held in a cell from its percentage display. Our rate cells contain the fractions 0.25 and 0.50. Multiplying their difference by 100 is the deliberate step used to express the point difference as the number 25; do not multiply the relative-change formula by 100 as well as applying percentage format.

Check the starting value and comparison scope

A relative percentage change needs a non-zero starting value. If the starting rate is zero, the division in this formula is undefined. Keep the point difference and the underlying counts visible, and state that the relative change is not calculated from that zero base. Do not replace it with 0% or an invented finite increase.

The direction matters too. Reversing 25% to 50% gives a relative increase of 100%; reversing 50% to 25% gives a relative decrease of 50%. The point difference has magnitude 25 in either direction, while its sign follows the order of subtraction.

Before interpreting a real comparison, confirm that both records cover the intended population, period and definition. If one report counts attendees against confirmed places and another against all invitations, the rates answer different questions. Correct labels or obtain comparable records before presenting them as a like-for-like change.

Write a result another person can reconstruct

For Mei's example, a clear note is: “Attendance rate increased from 10 of 40 places, or 25%, to 8 of 16 places, or 50%: up 25 percentage points, equivalent to a 100% relative increase in the rate. Attendance itself fell by 2 people.” This keeps the rate improvement separate from the headcount change.

Use this review sequence before sending a chart or summary:

1. Name the measure, period and population being compared.
2. Retain each numerator and denominator beside its rate.
3. Label the earlier value and the later value explicitly.
4. Calculate point difference and relative change in separate cells.
5. Check for a zero starting value and inconsistent definitions.
6. Read the result aloud with its unit: people, percentage points or percent.
7. Include the underlying counts when a rate could conceal a changing group size.

A chart title such as “Attendance doubled” would be wrong for these invented records. “Attendance rate doubled” describes the rates, but still benefits from the counts that reveal the smaller second session. Arithmetic establishes the stated comparison; it does not explain why the sessions differed.

FAQ

Is moving from 25% to 50% an increase of 25%?

It is an increase of 25 percentage points. Relative to the starting 25% rate, the increase is 100%. Include the unit so readers know which calculation you mean.

Can a higher rate mean fewer people?

Yes. In our invented example, 8 attendees out of 16 places gives a higher rate than 10 out of 40, while the headcount is lower. Compare counts as well as rates.

What should I report when the starting rate is zero?

Report the two rates, their point difference and their underlying counts. The relative-change formula here cannot divide by zero, so mark that result as not calculated rather than supplying a finite percentage.

Does this comparison show what caused the change?

No. The example contains two defined records and arithmetic. It supplies no evidence that a particular action caused the difference, and it does not forecast the next session.

Sources and scope

The Excel formula and display facts were checked on 24 October 2026 against Microsoft Support's Calculate percentages and Format numbers as percentages in Excel. No Microsoft example figures or case study are reproduced here.

The fictional session records, arithmetic, wording checks and review sequence were independently designed by i8 Live. This is a numeracy and spreadsheet-reading guide, not a claim about commercial returns or the performance of any real event.

Related reading

For a separate spreadsheet check, read about keeping records together when sorting and understanding active filters. When handing over a checked calculation, our formula or fixed-result guide explains how to choose the intended destination behaviour.