How do I calculate percentage change in a spreadsheet?
Subtract the old value from the new value, divide by the old value, and format the cell as a percentage. If the old value is in cell A2 and the new value is in B2, the formula is =(B2-A2)/A2. The cell shows the same result this page works out by hand.
Can a percentage change be more than 100 percent?
Yes, for increases. A value that doubles has risen by 100 percent, and a value that triples has risen by 200 percent. Decreases are capped the other way. A positive value cannot fall by more than 100 percent, because a 100 percent fall brings it to zero.
What is the difference between percentage change and percent difference?
Percentage change uses the old value as the base, because one value came first. Percent difference is used when neither value is the starting point, and it uses the average of the two values as the base instead. For before and after questions, percentage change is the right tool.
Why does the order of the values matter?
Because the base changes. Going from 80 to 100 is a 25 percent increase, but going from 100 back to 80 is a 20 percent decrease. The change is 20 in both directions, while the starting value is different, so the percentages differ.