Guide

Percentage change formula

How to calculate percentage change by hand, with the formula, the reason it divides by the old value, and worked examples straight from the US Bureau of Labor Statistics. The calculator below starts with the BLS twelve-month consumer price example.

  • The formula and the three steps
  • Official BLS worked examples, dated
  • Practice questions with answers

Examples and sources checked on November 21, 2026.

Percentage change+6.45%Increase

Going from 278.802 to 296.797 is an increase of 17.995, which is 6.45% of the starting value.

Absolute change+17.995
Multiplierx1.06454

Working

  1. Change: 296.797 - 278.802 = 17.995
  2. Divide by the starting value: 17.995 / 278.802 = 0.064544
  3. Times 100: 0.064544 x 100 = +6.45%

Spreadsheet formula Excel and Google Sheets

Put 278.802 in A2 and 296.797 in B2, then format the result cell as Percentage.

Cell formula=(B2-A2)/ABS(A2)
With your numbers=(296.797-278.802)/ABS(278.802)

Decimal comma form (semicolons): =(296,797-278,802)/ABS(278,802)

ABS keeps the sign right when the starting value is negative. For positive starting values it gives the same answer as =(B2-A2)/A2.

Reverse check

Going back from 296.797 to 278.802 is -6.06%, not -6.45%, because the base is now 296.797. Check: 278.802 x 1.064544 = 296.797.

The formula

Percentage change = (new value - old value) / old value x 100. The same thing can be written as (new / old - 1) x 100, which is often quicker on a calculator: divide, subtract 1, move the decimal point two places.

A positive result is an increase and a negative result is a decrease. The old value is the base, the thing you measure from, and that choice is what makes percentage change have a direction.

  1. Find the change: new minus old.
  2. Divide the change by the old value.
  3. Multiply by 100.

A one-month example from the BLS

The BLS factsheet on calculating percent changes uses the consumer price index for all urban consumers. From November 2021 to December 2021 the index went from 277.948 to 278.802.

Worked example: one month

  1. Change: 278.802 - 277.948 = 0.854 index points.
  2. Divide by the old value: 0.854 / 277.948 = 0.003073.
  3. Times 100: 0.3073%, which BLS publishes as 0.3%.

BLS shows the ratio as 0.003, which looks like it would give 0.3% directly. It does, but only because of rounding: the full figure is 0.003073. Statistics agencies calculate from the unrounded index values and round once, at the end. So should you.

A twelve-month example

Over the twelve months from December 2021 to December 2022, the same index went from 278.802 to 296.797: a change of 17.995 points, and 17.995 / 278.802 x 100 = 6.45%, published as 6.5%. That is the annual inflation rate quoted in the news for December 2022.

Comparing the same month a year apart matters. BLS warns that January to December is an eleven-month change, not a year. And an annual average is a different measure again: the 2021 average of the twelve monthly indexes was 270.97, the 2022 average was 292.655, and the change between averages is 8.0%, not the 6.5% December-to-December figure.

More official examples

SourceOldNewChange
BLS escalation factsheet (CPI escalation)229.815232.9451.3620%, published 1.4%
BLS classroom activity (graphing inflation)1801905.5556%, published 5.6%
BLS hypothetical, April 2016 to May 2016239.261240.2360.4%
CPI on the newer base, May 2015 to May 2016237.805240.2361.02%
CPI on the older base, same months712.357719.6411.02%

The last two rows come from the BLS paper Math calculations to better utilize CPI data. The index values are very different because the two series use different base periods, yet the percentage change is 1.0% on both at the published rounding. Points depend on the base; percentages do not.

Common mistakes

  • Dividing by the new value. From 100 to 125 is +25.00%. Dividing by 125 gives 20.00%, which is the size of the fall from 125 back to 100.
  • Reporting points as percent. A rate going from 4% to 5% has risen 1 percentage point, which is a 25% increase. See percentage points.
  • Adding percentages over time. Up 10% then down 10% is -1.00%, not zero. See successive changes.
  • Rounding too early. Round once, at the end.
  • Dividing by zero or a negative. From zero there is no percentage; from a negative number the sign needs care. See the negative numbers and zero guide.

Practice questions

Find the percentage change for each pair. Answers are below the questions.

  1. From 400 to 350
  2. From 240 to 600
  3. From 250 to 200
  4. From 480 to 420
  5. From 640 to 672
Show the answers
  1. -12.50% (a decrease of 50)
  2. +150.00% (an increase of 360)
  3. -20.00% (a decrease of 50)
  4. -12.50% (a decrease of 60)
  5. +5.00% (an increase of 32)

Five full printable sets with answer keys are on the worksheets page.