Percent Increase Formula: How To Calculate Growth Rate

Calculating percent increase is one of the most useful mathematical skills you'll ever use, whether you're tracking business revenue, measuring personal fitness milestones, or analyzing financial reports. The core formula is simple: subtract the old value from the new value, divide that difference by the original value, and multiply by 100. If your starting salary was $50,000 and it rose to $55,000, your increase is 10%.

Most articles on this topic stop at the basic equation. They leave out what happens when numbers drop into negative territory, how to chain multiple growth periods together, or how to set up automated formulas in Excel and Google Sheets without breaking your calculations. Let's break down the exact mechanics, real-world applications, and common mathematical traps so you can measure growth accurately every single time.

The Core Formula and Step-by-Step Breakdown

To find the percentage by which a number has grown, you need two data points: your starting baseline (the old value) and your ending point (the new value).

Here is the exact mathematical formula:

Percent Increase = [(New Value - Old Value) / Old Value] × 100

Let's walk through a concrete example. Imagine an online store had 1,200 monthly active users in January and 1,500 monthly active users in February.

1. Subtract the old value from the new value: 1,500 - 1,200 = 300. This is your absolute growth.
2. Divide the difference by the original value: 300 / 1,200 = 0.25.
3. Multiply by 100 to convert to a percentage: 0.25 × 100 = 25%.

The user base grew by 25%.

Why the Baseline Matters

The most common mistake people make is dividing by the new value instead of the original value. Always use the starting point as your denominator. If you divide by the final number, you are calculating a completely different metric—often called percent error or proportion of the total—which will distort your growth figures.

Handling Negative Numbers and Zero

Real-world data gets messy. Sometimes your starting point is negative, zero, or fluctuates across zero. Standard calculators and basic formulas break down in these scenarios unless you apply specific mathematical adjustments.

Starting at Zero

If your baseline value is zero—for instance, launching a brand-new product line that generates $5,000 in its first month—you cannot divide by zero. Mathematically, division by zero is undefined.

When reporting growth from a zero baseline, don't write "infinite percent increase" in formal business reports. Instead, state the absolute dollar gain clearly or measure growth starting from the first non-zero recording period.

Moving Through Negative Numbers

Suppose your net income went from -$10,000 last year to +$5,000 this year. If you plug standard numbers into the basic formula, you get:

[(5,000 - (-10,000)) / -10,000] × 100 = -150%

That result looks like a massive drop, but your business actually turned a profit. To measure growth accurately when crossing from negative to positive, use the absolute value of the starting point in your denominator, or switch to measuring absolute change alongside relative change to avoid confusing stakeholders.

Automating Calculations in Spreadsheets

When you're dealing with hundreds of rows of financial data, manual calculations slow you down. You can automate percent increase instantly using Microsoft Excel or Google Sheets.

Assume your old value is in cell A2 and your new value is in cell B2. Click into cell C2 and enter this exact formula:

=(B2-A2)/A2

Format cell C2 as a percentage by clicking the '%' icon on the toolbar. The spreadsheet software automatically multiplies the decimal by 100 and appends the percentage sign.

• Pro tip: To drag this formula down a column for thousands of rows, double-click the small green square in the bottom-right corner of cell C2.
• Data integrity check: Always make sure your columns are formatted correctly. If your spreadsheet returns a raw decimal like 0.15 instead of 15%, the cell formatting is set to General or Number rather than Percentage.

Practical Business and Personal Applications

Knowing the formula is only half the battle. You have to know when and how to apply it to make informed decisions.

Evaluating Marketing Campaigns

If your email marketing list generated $4,000 in sales last month and $5,200 this month, your campaign revenue grew by 30%. You can compare this 30% increase against your email platform subscription costs to see if your return on investment scales properly.

Tracking Personal Finance and Net Worth

If your total investments grew from $40,000 to $44,000 over six months, you experienced a 10% increase. According to financial guidance from Investor.gov, calculating periodic returns helps you evaluate whether your portfolio matches your long-term wealth accumulation targets.

Monitoring Site Traffic and Conversion Rates

Content creators and product managers track weekly active users to spot trends early. If page views jump from 10,000 to 12,500 after a site redesign, you have a clear 25% signal that the user experience update worked.

Frequently Asked Questions

What is the difference between percent increase and percentage points?

Percent increase measures the relative change between two numbers (e.g., growing from 10 to 15 is a 50% increase). Percentage points measure the arithmetic difference between two percentages. If an interest rate moves from 4% to 6%, it rose by 2 percentage points, but it represents a 50% increase in the rate itself.

Can percent increase be higher than 100%?

Yes. Whenever your new value is more than double your original value, your percent increase exceeds 100%. If sales jump from $1,000 to $3,000, the difference is $2,000. Dividing $2,000 by $1,000 and multiplying by 100 yields a 200% increase.

How do I calculate percent decrease using the same formula?

Use the exact same formula: [(New Value - Old Value) / Old Value] × 100. When the new value is smaller than the old value, your numerator will be negative, resulting in a negative percentage. For example, dropping from $200 to $150 gives you a -25% change, which indicates a 25% decrease.

Why does my spreadsheet show a weird decimal instead of a percentage?

Spreadsheets calculate percentages as decimals under the hood (e.g., 0.25 represents 25%). If your cell displays 0.25, you just need to apply the percentage format to that column or cell so the software multiplies it by 100 and displays the symbol.