ThisCalculator

Everyday

Percentage Variation Calculator: Formula & Use

Updated · Standard formula, shown below

Percentage variation 20.00 %
Absolute difference
20.00
Result
Starting value
100
You entered
Final value
120
You entered

This calculator works out the percentage variation (percentage difference) between two numbers: you enter a starting value and a final value, and it returns the change as a percentage of the starting value, plus the absolute difference. It handles increases and decreases, shows negative results for drops, and lets you compare any two quantities with a consistent formula.

Formula

The percentage variation (often called percent change or relative change) is calculated as:

Percentage variation = ((Final value − Starting value) / Starting value) × 100

  • Starting value (a) – the original or reference number, in any unit (dollars, kilograms, people, etc.).
  • Final value (b) – the number after the change, in the same unit.
  • Percentage variation – the result, expressed as a percentage. A positive result means an increase; a negative result means a decrease.

The formula uses the starting value as the denominator, not the average of the two values. That distinction matters: this is “percentage change” (relative to the original), not “percentage difference” (relative to the average), which some other calculators use.

Worked Example

Using the default values from the calculator above:

  • Starting value (a) = 100
  • Final value (b) = 120

Step 1 – Find the difference: 120 − 100 = 20

Step 2 – Divide by the starting value: 20 ÷ 100 = 0.2

Step 3 – Multiply by 100: 0.2 × 100 = 20%

The calculator shows 20.00% as the percentage variation and 20 as the absolute difference. That matches the formula output exactly.

When to Use Percentage Variation

Percentage variation is the standard way to express change over time or between two related measurements. Common situations include:

  • Price changes – a product goes from $50 to $60; the variation is 20%.
  • Population growth – a town grows from 10,000 to 10,800; that is an 8% increase.
  • Test scores – a student improves from 70 to 85; the improvement is 21.43%.
  • Weight or measurement changes – a recipe yields 500 g instead of 400 g; that is a 25% increase.

Use this calculator whenever you want to know how much something changed relative to its original value. It is not the same as a percentage of the total – for example, “what percent of 200 is 50?” uses a different formula (part ÷ whole × 100).

How to Read the Result

The result is a relative measure, not an absolute one. A 50% increase from 10 is only 5 units, but a 50% increase from 1,000 is 500 units. Always pair the percentage with the absolute difference to understand the real scale of the change.

When the final value is smaller than the starting value, the result is negative. For example, going from 200 to 150 gives −25%. Many people say “a 25% decrease” instead of “−25% variation,” but both mean the same thing.

If the starting value is zero, the formula is undefined because you cannot divide by zero. In that case, percentage variation has no meaningful value; you can only describe the absolute change.

Common Mistakes and Misconceptions

  • Using the wrong denominator – Some people divide by the final value or by the average. That gives a different number (the “percentage difference” or “relative difference”). For a change from 100 to 120, dividing by the average (110) gives 18.18%, not 20%.
  • Confusing percentage points with percentage change – If a rate goes from 4% to 5%, the percentage variation is 25% (because 1 ÷ 4 = 0.25), but the rate increased by only 1 percentage point. Both statements are true but describe different things.
  • Rounding too early – Rounding the intermediate difference (e.g., 1 ÷ 3 = 0.333) before multiplying by 100 can cause small errors. Keep full precision until the final step.
  • Ignoring the sign – A negative result is not an error; it indicates a decrease. Be careful when comparing two negative changes – a result of −10% is a smaller decrease than −20%.
  • Mixing units – Both values must be in the same unit. Comparing 100 meters to 1 kilometer without converting will give a wrong percentage (you would need to convert 1 km to 1000 m first).

Limits of the Formula

The percentage variation formula assumes a linear relationship and a meaningful starting point. It works well for most everyday comparisons but has limitations:

  • Zero or negative starting values – If the starting value is zero, the formula is undefined. If it is negative, the result can be misleading (e.g., going from −10 to −5 gives +50%, but the magnitude actually decreased).
  • Large changes – For very large changes (e.g., a 1000% increase), the result is mathematically correct but may be hard to interpret. A 1000% increase means the final value is 11 times the original.
  • Not symmetric – The variation from A to B is not the same as from B to A. Increasing from 100 to 150 is a 50% change, but decreasing from 150 to 100 is a −33.33% change. This asymmetry is intentional – it reflects the different reference points.

For comparing two values without a clear “starting” point (e.g., comparing prices in two different stores), the percentage difference (which uses the average as the denominator) may be more appropriate. This calculator uses the starting value, so choose which value is the reference before you calculate.

Frequently Asked Questions

What is the difference between percentage variation and percentage difference?

Percentage variation (or percent change) uses the starting value as the denominator: ((b − a) / a) × 100. Percentage difference uses the average of the two values as the denominator: ((b − a) / ((a + b) / 2)) × 100. For a change from 100 to 120, variation is 20%, while difference is 18.18%. Use variation when there is a clear original value (like last year’s price); use difference when comparing two equal-status values (like two competing products).

Can I use this calculator for percentage increase and decrease?

Yes. The same formula handles both. If the final value is larger, the result is positive (increase). If the final value is smaller, the result is negative (decrease). For example, from 80 to 100 gives +25%, while from 100 to 80 gives −20%. The calculator does not need a separate mode.

What if the starting value is zero?

You cannot divide by zero, so the percentage variation is undefined. In that case, you can only report the absolute change (e.g., “increased by 5 units”). Some fields use a convention like “infinite percentage increase,” but that is not mathematically valid and can be misleading. If your starting value is zero, consider using a different measure, such as the absolute difference.

How do I calculate percentage variation in Excel?

In Excel, if the starting value is in cell A1 and the final value is in B1, use the formula: =(B1-A1)/A1 and format the cell as a percentage. That gives the same result as this calculator. To show the absolute difference, use =B1-A1.

Does the order of the two numbers matter?

Yes. The formula is not symmetric. Swapping the starting and final values changes the denominator, so the result changes. For example, from 100 to 150 is +50%, but from 150 to 100 is −33.33%. Always decide which value is the original or reference before calculating.

What is a good percentage variation?

There is no universal “good” value – it depends entirely on the context. A 5% increase in a product’s price might be normal, while a 5% increase in a medical error rate would be alarming. Always interpret the percentage in light of the absolute change and the domain you are working in.

Related

Formula used
in a | Starting value | - | 100 | 0
in b | Final value | - | 120 | 0
out pct | Percentage variation | % | ((b - a) / a) * 100 | 2
out diff | Absolute difference | - | b - a | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.