Percentage Change Calculator
Calculate the percentage increase, decrease, or rate of growth between an old starting value and a new value instantly. Includes step-by-step math, Excel shortcuts, and visual examples.
Enter Starting & Ending Values
Find the percentage increase, decrease, or growth rate from an old starting value to a new value.
Complete Guide to Percentage Change
Everything you need to know: the exact formula, easy 3-step calculation instructions, spreadsheet shortcuts for Excel and Google Sheets, worked examples, and when to use percentage change vs. percentage difference.
What Is Percentage Change?
Percentage change tells you how much a number grew or shrank compared to where it started. Whenever you want to track a before-and-after change over time—such as a salary raise, a rent hike, stock market swings, or your website traffic this month—percentage change gives you the exact rate of that shift.
Everyday Examples of Percentage Change
We run into percentage change every single day. Here are a few familiar situations:
The 3 Core Rules of Percentage Change
Keep these three simple principles in mind whenever you calculate percentage change:
Order Matters
Going from $40 to $60 is a +50.00% increase, but dropping from $60 to $40 is a −33.33% decrease. The starting number sets the scale.
Positive vs. Negative Sign
A plus sign (+) always means growth or an increase. A minus sign (−) always means a loss, drop, or discount.
Needs a Starting Point
You must always divide by the original starting number. Without an initial baseline, you cannot measure how much progress was made.
The Percentage Change Formula
In plain words: Subtract the old number from the new number, divide by the old number, and multiply by 100.
The numerator New Value − Old Value is the raw dollar or unit change. The denominator |Old Value| is your original starting baseline.
((newValue - oldValue) / Math.abs(oldValue)) * 100Old Value (Starting Point)
Where you began before the change occurred. This could be last year's sales, your starting weight, or yesterday's stock price.
New Value (Ending Point)
Where you ended up. If New is greater than Old, you experienced growth (+); if New is less than Old, you experienced a drop (−).
Raw Difference (Change)
New − Old. Keeps its positive or negative sign to preserve the direction of growth or decline.
Turn Into a Percent
Multiplying the decimal ratio by 100 converts it into a standard percentage (%).
If you start with a negative number—like going from −$50 in credit card debt to −$25 in debt—our calculator uses the absolute value |Old Value| in the denominator.
This ensures the direction makes real-world sense: cutting your debt in half is a +50% financial improvement, not a negative decline.
How to Calculate Percentage Change in 3 Easy Steps
Calculating percentage change by hand or on a standard calculator takes just three quick steps:
Find the Raw Change
Subtract your starting number from your new number. Keep the sign: a positive number means growth; a negative number means a drop.
Change = New − OldDivide by Starting Value
Divide the change from Step 1 by the absolute value of your original starting number (|Old|) to find the decimal ratio.
Ratio = Change ÷ |Old|Multiply by 100
Multiply the decimal ratio by 100 and attach a percent sign (%). That gives you your final percentage change!
Percentage = Ratio × 100%How to Calculate Percentage Change in Excel & Google Sheets
Need to compare sales figures, quarterly profits, or marketing benchmarks in Microsoft Excel or Google Sheets? Use these formulas to calculate percentage change automatically across your columns.
Standard Spreadsheet Formula
Ideal for revenues, prices, website sessions, and everyday numbers where Old Value is in cell A2 and New Value is in cell B2.
Tip: After pasting, click the Percent Style (%) button on your toolbar to format the decimal as a percentage.
Negative Starting Value Formula
Essential when starting values can be negative (e.g. corporate net losses, sub-zero temperatures, or negative margins).
How it works: ABS(A2) ensures the denominator is positive so an improved deficit shows as a positive growth rate.
3 Easy Steps to Use in Your Spreadsheet:
- Enter your Starting Value (Old) in cell A2 and your Ending Value (New) in cell B2.
- Paste
=(B2-A2)/A2into cell C2 and press Enter. - Select cell C2 and click the Percent Style (%) button on the toolbar. Then drag the small bottom-right square down to apply the formula across all your rows!
Worked Examples & Interactive Table
Here is how the percentage change formula works across price jumps, markdowns, negative debts, and decimals. Click Load on any row to test it in the interactive tool above.
Detailed Walkthrough: Price Rising from $40 to $60
Suppose an item originally cost $40 and the price increases to $60:
| Old Value | New Value | Raw Change | Multiplier | Percentage Change | Scenario | Try It |
|---|---|---|---|---|---|---|
| 40 | 60 | +20.00 | 1.50x | +50.00% | Price increase from $40 to $60 (+50.00% gain) | |
| 60 | 40 | −20.00 | 0.67x | −33.33% | Price markdown from $60 to $40 (−33.33% drop) | |
| 50 | 125 | +75.00 | 2.50x | +150.00% | Traffic jumping from 50 to 125 (more than doubled) | |
| 100 | 100 | 0.00 | 1.00x | 0.00% | Identical numbers with zero change (0.00%) | |
| -50 | -25 | +25.00 | — | +50.00% | Debt cut from −$50 to −$25 (+50.00% recovery) | |
| 12.5 | 15.75 | +3.25 | 1.26x | +26.00% | Decimal measurement increase (+26.00%) |
Percentage Change vs. Percentage Difference
Percentage Change
Measures how a specific value moves up or down from an old starting baseline to a new ending figure.
- →Directional: An increase is positive (+); a decrease is negative (−).
- →Denominator: Divided strictly by the old starting baseline.
- →Order matters: 40 to 60 (+50%) is not the same as 60 to 40 (−33.33%).
Percentage Difference
Compares two equal values at the same time where neither number is the "original" or "starting" value.
- ✓Order doesn't matter: 40 vs 60 gives the exact same result as 60 vs 40.
- ✓Denominator: Divided by the average of both numbers.
- ✓Sign: Always positive (0% or greater).
Side-by-Side Comparison: Values of 40 and 60
See how the math changes depending on whether you're evaluating a price change over time or comparing two competitors side-by-side:
Frequently Asked Questions
Straightforward answers about calculating percentage change, why order matters, and spreadsheet tricks.