Percent change shows how much a value has grown or shrunk compared with where it started. It is used for prices, salaries, website traffic, investment returns and almost every report that compares one period with another. The formula is simple, but people often divide by the wrong number or mix up percentage points and percent. This guide covers the formula, percent increase and decrease, several worked examples with the arithmetic shown, how to reverse the calculation, and how to do it in Excel and Google Sheets.
Updated November 2026
In this guide
- The percent change formula
- Step-by-step method
- Worked example 1: a price increase
- Worked example 2: a decrease
- Worked example 3: website traffic
- Examples table
- How to find the new value from a percentage
- Percent change vs percentage points
- Percent change in Excel and Google Sheets
- Chaining several changes together
- Using percent change in business reports
- Percent change for discounts, taxes and tips
- Percent change vs percent difference
- Common mistakes and practice problems
The percent change formula
Percent change equals (new value minus old value) divided by the old value, multiplied by 100. The old value, also called the starting or original value, is always the denominator. A positive result is a percent increase and a negative result is a percent decrease. Keeping the sign makes the direction clear, which is why most reports use it. You can check any calculation with our rate of change calculator.

Step-by-step method
- Write down the old value and the new value.
- Subtract the old value from the new value.
- Divide the difference by the old value.
- Multiply by 100 and add a percent sign.
If the answer is positive, say increase. If it is negative, say decrease and drop the minus sign in the sentence.
Worked example 1: a price increase
A subscription rises from 40 dollars to 46 dollars. The difference is 6. Dividing by the old price, 6 divided by 40 is 0.15, so the increase is 15 percent. Dividing by the new price instead would give 13 percent, which is incorrect.
Worked example 2: a decrease
A store cuts a jacket from 80 dollars to 60 dollars. The difference is minus 20. Dividing by 80 gives minus 0.25, so the price fell 25 percent. A common surprise is that increasing the new price of 60 by 25 percent only returns it to 75, not 80, because the base is different. To get back to 80 you need a 33.3 percent increase, since 20 divided by 60 is 0.333.
Worked example 3: website traffic
A site had 12,400 visits in October and 15,500 in November. The difference is 3,100. Dividing by 12,400 gives 0.25, which is a 25 percent increase. If December drops to 13,950 visits, the change is 13,950 minus 15,500, which is minus 1,550, and dividing by 15,500 gives minus 0.10, a 10 percent decrease. Notice that a 25 percent rise followed by a 10 percent fall does not cancel out: 12,400 grew to 13,950 overall, a 12.5 percent gain.
Examples table
These rows are checked by hand.
| Old | New | Change | Percent change |
|---|---|---|---|
| 50 | 65 | +15 | +30.0% |
| 200 | 170 | -30 | -15.0% |
| 1,200 | 1,500 | +300 | +25.0% |
| 45 | 36 | -9 | -20.0% |
| 8 | 10 | +2 | +25.0% |
How to find the new value from a percentage
To apply a percent change, multiply the old value by 1 plus the rate for an increase, or by 1 minus the rate for a decrease. A 15 percent raise on a salary of 3,000 is 3,000 times 1.15, which is 3,450. A 20 percent discount on 250 is 250 times 0.80, which is 200. To undo a percent change, divide instead: if a price after a 20 percent discount is 200, the original was 200 divided by 0.80, which is 250. Reversing by adding 20 percent to 200 would give 240, a common error.
Percent change vs percentage points
If an interest rate goes from 4 percent to 5 percent, it rose by 1 percentage point, but the percent change is 1 divided by 4, which is 25 percent. Both statements are true and they mean different things. When you describe changes in rates, be clear which one you mean. Use percentage points for the simple difference and percent for the relative change.
Percent change in Excel and Google Sheets
With the old value in A2 and the new value in B2, type =(B2-A2)/A2 and format the cell as Percentage. Fill down to calculate a whole column. If some old values may be zero, guard the formula with =IF(A2=0,"n/a",(B2-A2)/A2). For a growth series, use =B3/B2-1 to compare each period with the previous one. Learn more in the Microsoft guide to the IF function.
Chaining several changes together
When a value changes more than once, do not add the percentages. Multiply the growth factors instead. A salary of 4,000 that rises 5 percent, then 8 percent, then falls 3 percent ends at 4,000 times 1.05 times 1.08 times 0.97, which is 4,000 times 1.0999, or about 4,399.6. The total change is therefore about 10.0 percent. That happens to be close to 5 plus 8 minus 3, which is 10, but the match is a coincidence for small numbers. Try 20 percent up then 20 percent down: 1.20 times 0.80 is 0.96, so you end 4 percent lower, not at zero, which shows why simple adding fails.
The same idea gives the average growth rate over several periods. If sales grow from 100 to 150 over three years, the total change is 50 percent, and the yearly rate is the cube root of 1.5 minus 1, about 14.5 percent per year. This is the compound annual growth rate, and it is more meaningful than dividing 50 by 3.
Using percent change in business reports
Month-over-month and year-over-year are the two most common comparisons. Month-over-month compares a month with the one before, which shows short-term movement but can be distorted by seasons. Year-over-year compares a month with the same month last year, which removes the seasonal pattern. When a report says revenue is up 12 percent, always ask which base period it compares with. Also check the size of the base: a jump from 5 to 10 orders is a 100 percent increase, but it is only 5 extra orders. Pairing the percent with the absolute number avoids misleading headlines.
Percent change for discounts, taxes and tips
Everyday percent changes follow the same rules. A 15 percent tip on a 48 dollar bill is 48 times 0.15, which is 7.20 dollars, for a total of 55.20. A sales tax of 8 percent on 125 dollars adds 10 dollars, for a total of 135. A 30 percent discount on a 90 dollar item takes off 27 dollars, leaving 63. If a second coupon gives another 10 percent off the sale price, the final price is 63 times 0.90, which is 56.70, a total reduction of 37 percent from the original and not 40 percent. Stores often stack discounts this way, so multiply factors rather than adding the percentages.
To find what percent one number is of another, divide the part by the whole. If 18 of 60 survey respondents chose option A, then 18 divided by 60 is 0.30, or 30 percent. This is not a change, just a share, but it is calculated with the same division and multiplication steps.
Percent change vs percent difference
Percent change has a direction: it starts from an old value and moves to a new one. Percent difference is symmetric and is used when two values are simply being compared, with neither one the starting point. It divides the gap by the average of the two numbers. For 40 and 50, the gap is 10 and the average is 45, so the percent difference is 22.2 percent. The percent change from 40 to 50 is 25 percent, and from 50 to 40 it is minus 20 percent. Pick the method that matches your story: use percent change for before and after, and percent difference when comparing two independent figures such as two stores or two lab results.
Finally, remember to state your base period and to show units clearly. A line such as “revenue rose 18 percent from 25,000 dollars in September to 29,500 dollars in October” gives the reader everything needed to check the claim.
Common mistakes and practice problems
Mistakes include dividing by the new value, adding percentages across periods, and ignoring a zero base. Practice: (1) 60 to 72. The change is 12, and 12 divided by 60 is 20 percent. (2) 500 to 425. The change is minus 75, and minus 75 divided by 500 is minus 15 percent. (3) 2.5 to 4. The change is 1.5 and 1.5 divided by 2.5 is 60 percent. Check with the calculator and read about percent error for a related idea.
Frequently asked questions
What is the formula for percent change?
Subtract the old value from the new value, divide by the old value, and multiply by 100.
What is the difference between percent increase and percent change?
Percent increase is a positive percent change. A negative result is a percent decrease.
Why is a 50 percent increase followed by a 50 percent decrease not zero?
The second percentage applies to a larger base, so 100 becomes 150 and then 75.
How do I calculate percent change in Excel?
Use =(new-old)/old and format the cell as a percentage.
What if the old value is zero?
Percent change is undefined, so report the absolute change instead.
Related guides and free tools
- How to Calculate Percent Difference
- Rate of change calculator
- Percent error calculator
- Annual income calculator
- How to calculate percent error
- All free calculators and templates
Sources: IF function, Microsoft Support


