Why Your Percentage Calculation Is Wrong: Percentage Change vs Percentage Points
Learn why percentage calculations go wrong: percentage change versus points, the wrong base, stacked discounts, reversing percentages, weighted averages, and spreadsheet mistakes.
Contents
- Start with the question: Percentage of what?
- The six percentage formulas worth keeping
- Mistake 1: Dividing by the new value instead of the original
- Why reversing the journey changes the percentage
- Mistake 2: Treating percentage points as percentages
- Percentage points are not basis points
- Mistake 3: Assuming a 20% rise and a 20% fall cancel
- Calculate a sequence of changes correctly
- Mistake 4: Adding discounts that apply one after another
- Discount plus tax: Check the order and the taxable amount
- Mistake 5: Trying to reverse a discount by adding it back
- How to reverse a percentage change
- Mistake 6: Confusing percentage change with percentage difference
- Percent error uses yet another reference
- Mistake 7: Treating a small percentage as a small change
- Zero and negative starting values need special treatment
- Mistake 8: Averaging percentages without considering group sizes
- Mistake 9: Confusing a test score with an increase in the score
- Mistake 10: Mixing up markup and gross margin
- Mistake 11: Treating every annual growth rate as the same thing
- A year-on-year change is not a percentage-point change
- Mistake 12: Entering 15 instead of 15% in a spreadsheet
- Why rounding too early can make reports disagree
- A quick diagnostic workflow for any percentage calculation
- Worked mini-cases: Which number should you report?
- Use the appropriate Horus Valley calculator
- Reliable sources and further reading
- The bottom line

A percentage can look perfectly reasonable while answering the wrong question. A price rises from $80 to $100: is that a 20% increase or a 25% increase? An interest rate moves from 4% to 5%: is that a 1% increase or a 1-percentage-point increase? And why does a 20% discount followed by another 10% discount not mean 30% off?
Most percentage mistakes are not caused by difficult arithmetic. They happen because someone chooses the wrong base value, confuses a percentage with a percentage point, or adds percentage changes that should be multiplied. This guide walks through the correct formulas, worked examples, spreadsheet checks, and practical ways to spot misleading results.
Quick answer: For ordinary percentage change, divide the change by the original value, not the new one: (New − Original) ÷ Original × 100. If a rate rises from 20% to 25%, it increases by 5 percentage points, but its relative increase is 25%. Those are different, simultaneously correct descriptions.
Start with the question: Percentage of what?
The percent sign means “per hundred.” Therefore, 15% means 15 out of every 100 parts of a specified whole, or the decimal 0.15. Without a clearly identified whole, the expression “15%” is incomplete in an important practical sense. OpenStax introduces percentages as fractions of a total, and the OpenStax explanation of rational numbers sets out that basic relationship.
For example, 15% of $200 is $30, but 15% of $80 is $12. The rate did not change; the base did. Before reaching for a calculator, write a short sentence describing what the answer should represent: “What share of the original price was saved?” or “By what percentage did this month’s revenue change from last month’s?”
- Part: the quantity you are describing, such as 18 correct answers.
- Whole or base: the amount against which you compare it, such as 24 questions.
- Rate: the result expressed per 100; 18 ÷ 24 × 100 = 75%.
- Direction: for changes, whether the new value is higher or lower than the base.
The six percentage formulas worth keeping
| What you need | Correct formula | Example |
|---|---|---|
| Percentage of a quantity | Quantity × Rate ÷ 100 | 15% of 200 = 30 |
| One number as a percentage of another | Part ÷ Whole × 100 | 18 of 24 = 75% |
| Percentage change | (New − Old) ÷ Old × 100 | 80 to 100 = +25% |
| Amount after an increase | Original × (1 + Rate ÷ 100) | 200 plus 15% = 230 |
| Amount after a decrease | Original × (1 − Rate ÷ 100) | 200 minus 15% = 170 |
| Original amount before a known change | Final ÷ (1 ± Rate ÷ 100) | 80 after 20% off means original 100 |
The percentage-change formula assumes a meaningful, nonzero starting value. The final line uses plus for a previous increase and minus for a previous decrease. Enter the percentage as a whole number in these displayed formulas: 15 means 15%, not 0.15. In spreadsheets with a cell already formatted as a percentage, use the cell directly instead of dividing its value by 100 again.
For a quick result without manually retyping formulas, the free Horus Percentage Calculator has separate modes for a percentage of a number, percentage change, and percentage difference. Choosing the correct mode is part of getting the correct answer.
Mistake 1: Dividing by the new value instead of the original
Suppose your weekly grocery bill increased from $80 to $100. The dollar increase is $20. Since you are asking how much the bill grew relative to what you used to pay, $80 is the denominator.
- Subtract the old amount from the new: 100 − 80 = 20.
- Divide by the old amount: 20 ÷ 80 = 0.25.
- Multiply by 100: the increase is 25%.
Using 20 ÷ 100 = 20% measures the difference as a share of the new bill. That can be a useful question, but it does not answer “How much did the bill increase from its previous level?” The US Bureau of Labor Statistics instructions for calculating percent changes likewise calculate movement by dividing by the earlier index value.
Why reversing the journey changes the percentage
A fall from $100 to $80 is a 20% decrease, because the $20 drop is 20% of $100. Going back from $80 to $100 requires a 25% increase, because the same $20 is 25% of $80. The dollar difference is symmetric; the relative percentage change is not.
A reliable diagnostic: Say out loud which value is 100% of the comparison. If you cannot name that value, do not trust the resulting percentage yet.
Mistake 2: Treating percentage points as percentages
This error appears in news reports, unemployment statistics, test pass rates, interest rates, election surveys, and marketing dashboards. It is important because the two numbers can differ dramatically.
Imagine a company’s conversion rate goes from 4% to 5%. The arithmetic difference is 1 percentage point (5 − 4). The relative rate increase, however, is (5 − 4) ÷ 4 × 100 = 25%. Describing it only as “a 1% increase” can mislead readers about what was measured.
The UK Office for National Statistics style guide explicitly distinguishes a percentage-point change from a percentage change. Its example notes that a decline of one percentage point from 10% reaches 9%, whereas a 1% relative decline reaches 9.9%.
| Starting rate | Ending rate | Change in percentage points | Relative percentage change |
|---|---|---|---|
| 4% | 5% | +1 point | +25% |
| 20% | 25% | +5 points | +25% |
| 50% | 45% | −5 points | −10% |
| 2% | 3% | +1 point | +50% |
| 10% | 9% | −1 point | −10% |
Percentage points are not basis points
Finance and rate announcements may also use basis points. One percentage point equals 100 basis points. A move from 4.00% to 4.50% is +0.50 percentage point, or +50 basis points. Relative to the original 4% rate, that is a 12.5% increase in the numerical rate. In any financial comparison, check whether a quoted change refers to a rate, a payment, or a total cost; those are not automatically interchangeable.
Mistake 3: Assuming a 20% rise and a 20% fall cancel
Start with $100. A 20% increase produces $120. A subsequent 20% reduction is taken from $120, so it removes $24 and leaves $96. You end 4% below the starting value, not where you began.
The correct method is to apply each change to the latest amount using multipliers:
- Increase by 20%: multiply by 1.20.
- Decrease by 20%: multiply by 0.80.
- Combine them: 100 × 1.20 × 0.80 = 96.
- Find net change: (96 − 100) ÷ 100 × 100 = −4%.
The same principle applies to rent reviews, subscription prices, business revenue, and investment performance. An initial 10% rise followed by a 10% fall produces 1.10 × 0.90 = 0.99, or a net 1% loss. Each stage changes the base for the next stage.
Calculate a sequence of changes correctly
For a sequence of percentage rates expressed as decimals, the final multiplier is (1 + r1) × (1 + r2) × …; a decrease has a negative rate. Two successive increases of 10% create a multiplier of 1.10 × 1.10 = 1.21, equivalent to a 21% overall increase rather than 20%.
| Successive changes | Combined multiplier | Final amount from $100 | Overall change |
|---|---|---|---|
| +10%, then +10% | 1.10 × 1.10 = 1.21 | $121 | +21% |
| +20%, then −20% | 1.20 × 0.80 = 0.96 | $96 | −4% |
| −20%, then −10% | 0.80 × 0.90 = 0.72 | $72 | −28% |
| +15%, then −10% | 1.15 × 0.90 = 1.035 | $103.50 | +3.5% |
Mistake 4: Adding discounts that apply one after another
Suppose a jacket costs $150. A shop applies 20% off, followed by an extra 10% off the reduced price. The discounts do not add to 30% of the original price.
- First discount: $150 × 0.80 = $120.
- Additional discount: $120 × 0.90 = $108.
- Total savings: $150 − $108 = $42.
- Effective discount: $42 ÷ $150 × 100 = 28%.
If a promotion instead says “30% off the original price,” that would lead to $105. Promotional conditions and exclusions still matter. A percentage is not self-explanatory until you know which price it applies to. OpenStax’s guide to discounts, markups and sales tax provides an accessible reference for working with different price bases.
Discount plus tax: Check the order and the taxable amount
As a hypothetical arithmetic example, a $100 item with 10% off becomes $90. If 8% sales tax is applied to that discounted price, the tax is $7.20 and the checkout total is $97.20. The total depends on which amount is taxable and the rules that apply to the transaction; jurisdictions and product types can differ.
For everyday price comparisons, use the Horus Discount Calculator to separate the original price, discount, and optional tax rather than merging all percentages into one figure.
Mistake 5: Trying to reverse a discount by adding it back
An item now costs $80 after a 20% discount. Adding 20% to $80 gives $96, not the original price. The reason is that the $80 represents 80% of the original amount, not 100%.
Divide the final price by the remaining fraction: Original = 80 ÷ 0.80 = $100. Similarly, if a bill is $138 after a 15% increase from a known base, the earlier bill was 138 ÷ 1.15 = $120.
How to reverse a percentage change
- After a 10% increase: divide the final amount by 1.10.
- After a 25% increase: divide by 1.25.
- After a 20% decrease: divide by 0.80.
- After a 35% decrease: divide by 0.65.
This works only if the claimed change and its reference base describe the complete transformation. Extra fixed fees, different tax bases, or a sequence of distinct rate changes require separate steps.
Mistake 6: Confusing percentage change with percentage difference
Percentage change is directional and uses an original value: from 40 to 50, the change is (50 − 40) ÷ 40 × 100 = 25%. Going in reverse gives −20%. The direction matters.
Percentage difference sometimes means a symmetrical comparison between two positive measurements, with neither selected as the original. A common convention uses the average of the two values as the denominator:
Symmetrical percentage difference = |A − B| ÷ ((|A| + |B|) ÷ 2) × 100 for positive A and B (where the absolute-value notation is redundant for the denominator). With 40 and 50, the average is 45, so 10 ÷ 45 × 100 ≈ 22.22%.
Not every industry uses the phrase percentage difference this way. Some sources use it loosely to describe relative change or percent error. Define the denominator in the report or calculator before comparing results. The Horus Percentage Calculator provides a dedicated difference mode, but always verify the intended formula when values come from a particular technical standard.
Percent error uses yet another reference
For a measurement of 525 against an accepted reference value of 500, the absolute percent error is |525 − 500| ÷ |500| × 100 = 5%. The reference is the accepted value, not the average of 525 and 500. Percent error, percentage change, and symmetrical percentage difference solve different problems.
Mistake 7: Treating a small percentage as a small change
If a quantity moves from 2 to 6, the change is 4 in absolute terms but 200% relative to the original 2. That 200% increase sounds dramatic because the starting base was small. Meanwhile, moving from 20,000 to 21,000 is only a 5% increase even though it adds 1,000 units.
Neither percentage is wrong. Problems arise when a headline provides only the relative percentage and conceals the underlying number of people, transactions, or events. In business reports, show both absolute change and relative percentage change, along with the original count. For comparisons between groups, the denominator is part of the story.
Zero and negative starting values need special treatment
When the original value is zero, the ordinary percentage-change expression divides by zero, so it is undefined. A change from zero sales to 20 sales should be reported as “20 additional sales” or “from 0 to 20,” not “an infinite percentage growth rate.”
When the original value is negative, a mechanical calculation can be counterintuitive. Moving a business result from a loss of −$100 to a profit of $50 is a $150 improvement. A formula dividing by −100 produces −150%, which is not a clear way to communicate improvement. State the absolute movement and explain any special rate convention instead. Do not apply a positive-base growth formula blindly to losses or to data that cross zero.
Mistake 8: Averaging percentages without considering group sizes
Imagine two classrooms. The smaller class has 10 students and 90% pass, meaning 9 students pass. The larger class has 90 students and 50% pass, meaning 45 pass. Averaging 90% and 50% gives 70%, but that is not the overall pass rate.
The correct overall result is (9 + 45) ÷ (10 + 90) × 100 = 54%. The two classes have different sizes, so their rates cannot receive equal weights if your question is “What percentage of all students passed?”
| Group | Students | Pass rate | Students passed |
|---|---|---|---|
| Class A | 10 | 90% | 9 |
| Class B | 90 | 50% | 45 |
| Combined | 100 | 54% | 54 |
For an aggregate percentage, total the parts and total the relevant bases, then divide. A simple average of separate rates is valid only when equal weighting is appropriate to the question. This follows the general proportion framework explained in OpenStax’s chapter on visualizing data.
Mistake 9: Confusing a test score with an increase in the score
A student who answers 36 of 45 questions correctly has a score of 80%. If the same 36 correct answers are recorded out of 50 questions, the percentage is 72%. The count of correct answers is unchanged, but the whole has changed.
Now suppose a student’s score rises from 70% on one test to 80% on another. That is a rise of 10 percentage points. Relative to 70%, the numerical rate rose by approximately 14.29%. Neither result says “10 additional questions” without knowing how many questions were on both tests. In education data, distinguish raw counts, rates, and changes in rates.
Mistake 10: Mixing up markup and gross margin
A shop buys a product for $80 and sells it for $100. The gross profit is $20 before other business costs. Markup on cost is 20 ÷ 80 × 100 = 25%. Gross margin on selling price is 20 ÷ 100 × 100 = 20%.
The two percentages describe the same transaction from different bases. If you set prices to hit a 25% gross margin, you cannot simply add 25% to cost. For an $80 cost, the selling price needed for a 25% gross margin is 80 ÷ (1 − 0.25) ≈ $106.67, giving about $26.67 gross profit.
This is a common budgeting and retail reporting error. Be explicit about whether a rate is defined as a fraction of cost, revenue, sale price, or another quantity. The OpenStax treatment of markups illustrates calculations based on wholesale cost.
Mistake 11: Treating every annual growth rate as the same thing
A value increases from $100 to $121 over two years. The total two-year increase is 21%. But the annual compound growth rate is not 21% and should not be described as such. If growth had been constant each year, the annual rate would solve (1 + r)² = 1.21, yielding 10% per year.
For a positive starting and ending amount over n periods, the compound annual growth rate (CAGR) is (Final ÷ Initial)^(1/n) − 1, expressed as a percentage. It is a mathematical equivalent constant growth rate, not proof that each actual year experienced equal growth. A simple annual average of observed yearly percentage changes answers another question and may give another number.
A year-on-year change is not a percentage-point change
When economic indicators such as consumer price indexes are compared over time, official statistical agencies typically express the movement of the index as a percentage of the earlier index. The BLS methodology explains this earlier-index denominator. Separately, a published rate may itself rise or fall by a number of percentage points. State whether you mean the underlying index’s growth or the change in a reported rate.
Mistake 12: Entering 15 instead of 15% in a spreadsheet
Excel and Google Sheets store 15% as 0.15. Typing 15 into a percentage-formatted cell may display 1500%, or a later formula may multiply by 15 rather than by 0.15. In other cases, someone enters 0.15 and then divides by 100 again, understating the answer by a factor of 100.
Here is a practical setup where A2 contains the old value and B2 contains the new value:
=(B2-A2)/A2Format the result cell as a percentage. For a percentage of a total, when C2 contains a rate stored as 15%, multiply directly:
=A2*C2To prevent errors when the previous amount might be zero, validate the input explicitly. In a spreadsheet, an example is =IF(A2=0,"Not defined",(B2-A2)/A2). This intentionally reports that ordinary percentage change from zero is undefined. When a spreadsheet has non-numeric text, blanks, or missing observations, decide how you want to handle those separately; do not automatically replace unknown values with zero.
Why rounding too early can make reports disagree
Take an original value of 63 and a new value of 64. Percentage change is (64 − 63) ÷ 63 × 100 ≈ 1.5873%. Rounding to 2% before using it in another calculation loses information; rounding each stage of a multi-step calculation may compound errors.
Keep sufficient precision through intermediate steps. Round once at the reporting stage, use a consistent number of decimal places for comparable rates, and specify whether differences between displayed rounded figures are calculated from their underlying unrounded values. The ONS guidance on presenting percentages also recommends consistent decimal presentation.
A quick diagnostic workflow for any percentage calculation
Before you publish a spreadsheet, quote a result, or decide whether an offer is worthwhile, run through these checks:
- Name the question: share of a whole, relative change, percentage-point movement, percentage difference, error, or a compounded change?
- Identify the base: original price, total respondents, older index, accepted reference, or current balance?
- Check the denominator: is it the base intended by the question, and is it nonzero?
- Convert rates correctly: 8% = 0.08, while 8 is 800% when interpreted as a raw multiplier rate.
- Check sequence: if one change happens after another, multiply the remaining or growth factors instead of adding rates.
- Audit the label: “percentage points” for changes between rates; “percent increase” for changes relative to the old rate.
- Show context: include original and final quantities when a percentage could hide a small base or different sample sizes.
- Recalculate independently: use the correct mode in a calculator, and compare the result with an estimate.
A useful mental check: a 50% increase from $100 should land at $150, while a 50% decrease from $100 should land at $50. If your answer goes the wrong direction, or a modest change creates an implausible result, pause and inspect your denominator and percentage format.
Worked mini-cases: Which number should you report?
| Situation | Tempting but wrong description | Correct result |
|---|---|---|
| Bill $80 → $100 | “20% more” | 25% increase from $80 |
| Interest rate 4% → 5% | “1% higher” without context | +1 percentage point; +25% relative rate |
| $100 +20%, then −20% | “Back to $100” | $96, net −4% |
| $150 with 20% then 10% off | “30% discount” | $108, effective 28% off |
| $80 after 20% off | “Original was $96” | Original was $100 |
| Measured 525 vs reference 500 | “Compare to average of both” | 5% absolute error, using 500 as reference |
| Rates 90% of 10 and 50% of 90 | “Average is 70%” | 54% overall across 100 people |
| Selling price $100, cost $80 | “25% gross margin” | 25% markup, 20% gross margin |
The table is a set of illustrative arithmetic examples, not financial, statistical, or tax advice. In a real report, defining the metric and its sample size is as important as performing the calculation correctly.
Use the appropriate Horus Valley calculator
For a percent of a number, ordinary percentage change, or a symmetrical difference between values, open the Horus Percentage Calculator. Enter your original and final amounts in the correct mode, read the result, then use the explanations above to decide how to describe it accurately.
For a price reduction with optional tax, the separate Discount Calculator is designed for that workflow. Neither calculator can choose the right base or metric for an ambiguous real-world question; that decision still needs to be made by the person preparing the calculation.
Reliable sources and further reading
- US Bureau of Labor Statistics — Calculating Percent Changes: the conventional percent-change denominator for index comparisons.
- UK Office for National Statistics — Percentages and Percentage Points: precise language and the difference between relative percentage changes and percentage-point movements.
- OpenStax — Rational Numbers and Percentages: definitions of percentages as parts of a whole.
- OpenStax — Discounts, Markups and Sales Tax: worked business arithmetic.
- OpenStax — Visualizing Data: proportions and the importance of group totals.
The bottom line
The best way to avoid a wrong percentage is to write down the base before you calculate. Use the original amount for conventional percentage change, subtract two reported rates for percentage-point movement, apply successive changes as multipliers, and aggregate percentages using the relevant group sizes. When a result looks counterintuitive, it may not be the arithmetic that’s wrong: it may be the question your formula answered.
