Numbers can be sneaky.

One day, your sales are steady.

The next, they're soaring. Or worse – plummeting.

Raw numbers alone don't tell the full story.

A $2,000 increase might sound amazing… until you realize it’s only a 2% gain.

That is why percentage change is so important. It gives context to the chaos.

It allows you to pull back the curtain to see what is really happening.

And Excel is your secret weapon in doing this.

Excel turns percentage change into something anyone can calculate, even if math isn’t your thing.

It is simple, logical, and effective.

You don’t have to be a financial analyst or a data guru to use it.

You just need to know a few tricks, and you’ll be zipping through spreadsheets like a pro.

In this guide, we'll not only teach you the basics of the percentage change formula in Excel, but also give you a toolkit for tackling numbers with ease and confidence.

Let's get started.

What is Percentage Change and Why Does it Matter?

Percentage change is how you measure the shift between two numbers.

It answers a simple but crucial question:

How much did something grow, shrink, or move as a percentage of where it started?

The formula is straightforward:

Percentage Change = [(New Value – Old Value) / Old Value] x 100

It is the difference between two numbers, divided by the original number, then multiplied by 100 to express it as a percentage.

That’s it. No need for any fancy calculators or mental gymnastics.

But why does percentage change matter? Because raw numbers on their own can only tell you so much.

Imagine your revenue increased by $50,000.

Sounds amazing, right? Not necessarily.

If your starting revenue was $5 million, that’s only a 1% increase.

On the flip side, a $50,000 bump on a $100,000 base is a jaw-dropping 50% growth.

See the difference? Context is everything.

And this is precisely where percentage change shines: it transforms raw data into actionable insights.

Whether you’re tracking performance, measuring success, or comparing trends, percentage change cuts straight through the noise.

Some common places where it’s essential:

• Stock Price Analysis: What’s the percentage change in your favorite stock? Did it climb 10% today or just 0.1%? Big difference.
• Revenue Tracking: Are sales growing month-over-month or year-over-year? Percentage change helps you pinpoint trends.
• Cost Analysis: Did material costs increase by 5% or 50%? Knowing the percentage difference can make or break your budget.

Step-by-Step Guide: Calculating Percentage Change in Excel

Step 1: Setting Up Your Data

Before diving into formulas, you need to organize your data in a way Excel understands. Here’s a simple structure to get started:

Old Value	New Value
100	150
200	180
500	300

• In Column A, list the original values (Old Value). These could represent last month’s revenue, last year’s sales, or the starting price of a stock.
• In Column B, list the updated values (New Value). These represent the current numbers you’re comparing to the old ones.

This setup makes it easy to reference the correct values when writing your formulas.

Step 2: Writing the Formula

Now for the fun part: calculating the percentage change.

Here’s the formula: =(B2−A2) / A2 x 100

What’s happening here?

• (B2 – A2): This subtracts the Old Value from the New Value to find the difference.
• / A2: Dividing by the Old Value gives you the change relative to the starting point.
• * 100: Multiplying by 100 converts the result into a percentage.

How to Write the Formula in Excel:

1. Click on the first empty cell in Column C (let’s call this the Percentage Change column).
2. Type the formula:
   =(B2 - A2) / A2 * 100
3. Hit Enter, and voila! You’ll see the percentage change for the first row.
4. Drag the formula down to apply it to all rows.

Formatting as a Percentage:

By default, Excel will display the result as a decimal (e.g., 0.5 for 50%). To make it look like a proper percentage:

1. Highlight the cells in the Percentage Change column.
2. Go to the Home tab, find the Number section, and click the Percent Style (%) button.
3. Adjust the decimal places if needed (e.g., 2 decimal points for 50.00%).

Step 3: Handling Negative Values

What happens when numbers drop instead of rising?

Negative values are Excel’s way of showing decreases, and they’re just as important to understand.

Example:

If revenue drops from $500 to $300, here’s how the formula works:
=(300−500) / 500 x 100 =−40%

The result is -40%, meaning your revenue fell by 40%.

Key Tip: Interpreting Negative Results

• A negative percentage means a decrease.
• A positive percentage means an increase.
• Zero means no change.

Pro Tip: To make your spreadsheet more intuitive, you can add conditional formatting to highlight positive changes in green and negative changes in red. This adds instant visual clarity to your data.

Step 4: Practical Examples

Let’s put everything together with a small table of examples to bring the concept to life:

Old Value	New Value	Percentage Change Formula	Result
100	150	=(150 - 100) / 100 * 100	50%
200	180	=(180 - 200) / 200 * 100	-10%
500	300	=(300 - 500) / 500 * 100	-40%
1,000	1,200	=(1200 - 1000) / 1000 * 100	20%

Visual Example:

If you’re working with sales data, your spreadsheet might look like this:

Learn how to pull historical stock prices directly into Excel with our guide on using the Stockhistory function in Excel.

Month	Old Sales	New Sales	% Change
January	$10,000	$15,000	50%
February	$8,000	$6,400	-20%
March	$12,500	$13,750	10%

Adding color-coded percentage changes makes trends easy to spot at a glance.

Pro Tip: Absolute References for Large Datasets

If you’re applying the formula across a large dataset but need to lock specific cells, use absolute references by adding a $ symbol. For example:

= (B2−A2) / $A$2 x 100

This locks the reference to A2, so Excel doesn’t adjust it when dragging the formula.

Common Scenarios and Advanced Use Cases

When you understand how to calculate percentage change, it opens the door to a whole new level of insights.

Whether you’re running a business, keeping tabs on your investments, or simply tracking personal goals, percentage change helps you see the bigger picture. It’s how you spot trends, compare progress, and make sense of shifts in your numbers.

Let’s look at how this simple formula can work its magic in real-world scenarios:

1. Year-over-Year (YoY) Changes

Year-over-year comparisons are essential for tracking long-term growth or decline. Businesses often use this to assess their performance relative to the same period in the previous year.

Here’s how it works:

Scenario:

You’re tracking your annual revenue. In 2023, your revenue was $1.2 million, and in 2022, it was $1 million. The percentage change formula reveals your growth rate:

Formula: = (B2 − A2) / A2 x 100

Year	Revenue ($)	% Change
2022	1,000,000	–
2023	1,200,000	20%

How to Use in Excel:

1. List your revenue values for each year in Column A (Old Value) and Column B (New Value).
2. Apply the formula in Column C to calculate the YoY change.
3. Format the results as percentages.

Pro Insight: Use YoY analysis to measure consistent growth and evaluate the impact of business strategies.

2. Month-over-Month (MoM) Analysis

MoM analysis focuses on short-term performance, helping you understand how metrics like sales, expenses, or website traffic change from one month to the next.

Scenario:

You’re tracking sales data for January and February. January’s sales were $80,000, and February’s were $92,000. The formula reveals:

Formula: = (92,000 − 80,000) / 80,000 x 100 = 15%

Month	Sales ($)	% Change
January	80,000	–
February	92,000	15%

Why It’s Useful:

MoM analysis is perfect for spotting seasonal trends or assessing the immediate impact of campaigns or events.

Pro Insight: Use conditional formatting to highlight significant increases (e.g., >10%) or decreases (e.g., <-10%).

3. Stock or Investment Portfolio Performance

If you’re monitoring stocks or investments, percentage change is essential to calculate gains or losses over time.

Scenario:

You bought 100 shares of a stock at $50/share, and the current price is $65/share.

What’s the percentage change in the stock price?

Formula: =(65 − 50) / 50 x 100 = 30%

Stock	Buy Price ($)	Current Price ($)	% Change
Stock A	50	65	30%
Stock B	100	80	-20%

Why It’s Useful:

• Track performance: Identify which stocks in your portfolio are outperforming or underperforming.
• Decision-making: Determine when to sell or hold based on performance trends.

Pro Insight: Use a combination of percentage change and absolute values to assess whether a gain/loss is meaningful in dollar terms.

Advanced Tips for Power Users

1. Highlighting Significant Changes with Conditional Formatting

Visual cues make data insights pop. By applying conditional formatting, you can automatically highlight large increases or decreases in your percentage changes.

How to Do It:

1. Select the column with your percentage change values.
2. Go to Home > Conditional Formatting > New Rule > Format cells that contain.
3. Set rules, such as:
   • Green for values >10% (positive changes).
   • Red for values <-10% (negative changes).

Why It’s Useful: This lets you instantly identify the most important changes in large datasets, saving time and reducing errors.

2. Linking Percentage Change to Dashboards

Want to impress your team with interactive insights? Link percentage change calculations to dashboards or pivot tables to create dynamic visualizations.

Example:

• Use a pivot table to show percentage changes across different categories (e.g., regions, product lines, or time periods).
• Add slicers to filter data in real time and see how percentage changes vary by segment.

Check out our tutorial on creating a stock screener in Google Sheets for even more powerful data insights.

Pro Insight: Combine percentage change with Excel charts (like line or bar charts) for an easy-to-read visual representation of trends over time.

Why Wisesheets Makes Excel Easier

Excel was built to handle numbers, but it wasn’t built to handle the chaos of today’s financial data.

That’s where things usually get tricky: pulling in the latest revenue numbers, tracking stock prices, or analyzing trends across companies can turn into hours of manual work.

Wisesheets changes that.

With just a few clicks, it connects your Excel sheet directly to live data streams (like revenue reports from Apple or historical stock prices for Amazon) and keeps everything up to date automatically.

Prefer Google Sheets? Check out how to get all the stock data you need in Google Sheets.

1. Live Data, Right in Your Spreadsheet

With Wisesheets, you can pull live financial data straight into Excel. This means you’re always working with the latest numbers, whether it’s stock prices, historical data, or company revenue.

Example: Apple’s Revenue Data

Let’s say you’re analyzing Apple’s revenue to calculate the percentage change between quarter 3 and quarter 4 of 2024. Instead of hunting down data manually, you can use Wisesheets to fetch historical revenue data for Apple (ticker: AAPL) with a simple command.

How It’s Done:

• In your Excel sheet, enter the Wisesheets formula for pulling the 2024 Q3 revenue:
  =WISE("AAPL"; "Revenue"; 2024; "Q3").
  
• Similarly, enter the formula for the 2024 Q4 revenue:
  =WISE("AAPL"; "Revenue"; 2024; "Q4")
  
• Let Wisesheets populate the revenue data instantly.

• Use the percentage change formula (=(New Value - Old Value) / Old Value * 100) to calculate growth or decline between quarters.

2. Automate Stock Performance Tracking

Say you’re managing a portfolio and want to track stock price growth for companies like Amazon, Apple, or Tesla.

Wisesheets allows you to pull historical stock prices directly into Excel, making it easy to calculate percentage changes over time.

Example: Stock Price Growth

Let’s analyze Apple’s stock price over a one-month period, from January 1, 2024, to January 31, 2024. The formula becomes:

How It's Done:

• In an empty cell, type the following formula:
  =WISEPRICE("AAPL", "Open",, "2024-01-01", "2024-01-31")
  Replace "AAPL" with the desired stock ticker and adjust the date range to suit your analysis.

• Press Enter, and Wisesheets will automatically fetch the opening prices for each available trading day within the selected date range.

• Organize the data in two columns: one for the Date and another for the Open Price ($). Wisesheets populates this for you, so it’s ready to work with.

• Add a third column labeled % Change. Use the percentage change formula to calculate the performance between specific dates:
  = (B2 – A2) / A2 * 100
  A2: Stock price for the earlier date.
  B2: Stock price for the later date.
  Drag the formula down to calculate the percentage change for all date pairs in your table.

• Once you’ve calculated the percentage changes, you can visualize the data or use conditional formatting to highlight key trends (e.g., positive changes in green, negative changes in red).

3. Streamlining Historical Data for Dashboards

One of Wisesheets’ most powerful features is its ability to integrate live or historical data into dynamic dashboards.

For example, if you’re building a dashboard to track stock performance across your portfolio, Wisesheets can continuously pull data for all your stocks and update calculations like percentage change in real time.

Looking to organize your investments? Download our free investment tracking spreadsheet for Google Sheets and Excel.

Dynamic Dashboard Example:

• Use Wisesheets formulas to pull historical prices for multiple stocks.
• Apply conditional formatting to highlight the top-performing stocks.
• Create charts or graphs to visualize percentage change over time.

Troubleshooting Common Issues with the Percentage Change Formula in Excel

Even the best formulas can run into trouble if you don’t set them up properly.

When calculating percentage change in Excel, a few common mistakes can throw off your results or lead to confusing error messages.

Let’s break these down and learn how to fix them.

Mistake 1: Dividing by Zero

The dreaded #DIV/0! error is one of the most common issues in Excel.

It pops up when you try to divide a number by zero, or when a cell that’s supposed to contain the “Old Value” is blank or zero.

Why This Happens

The percentage change formula involves dividing by the “Old Value” (the denominator).

If the “Old Value” is zero or the cell is empty, Excel can’t perform the calculation and throws the #DIV/0! error.

How to Fix It

You can prevent this error by wrapping your formula in an IFERROR function, which lets you replace the error with a custom message (e.g., “N/A” or 0%).

Corrected Formula:

=IFERROR((B2 - A2) / A2 * 100, "N/A")

Explanation:

• (B2 - A2) / A2 * 100: The standard percentage change formula.
• "N/A": The message Excel will display if there’s an error (e.g., dividing by zero).

Example:

Old Value	New Value	% Change Formula	Result
100	150	=(B2 - A2) / A2 * 100	50%
0	150	=IFERROR((B2 - A2) / A2 * 100, "N/A")	N/A

Pro Tip: If you want to replace "N/A" with 0% for a more consistent look, simply use "0" instead:

=IFERROR((B2 - A2) / A2 * 100, 0)

Mistake 2: Incorrect Cell References

When working with large datasets, it’s common to drag formulas down a column to apply them to multiple rows.

However, if your formula includes relative cell references (e.g., A2 or B2), Excel will adjust those references as you drag, which can lead to errors.

Why This Happens

By default, Excel uses relative referencing, meaning the cell references in your formula change as you move it. For example:

• Formula in Row 2: (B2 - A2) / A2
• Formula in Row 3: (B3 - A3) / A3

While this works for most scenarios, problems can occur if your formula needs to reference a fixed cell (e.g., a constant value like the overall baseline).

How to Fix It

Use absolute references by adding $ symbols to the parts of the reference that should stay fixed. For example:

• $A$2 locks both the column (A) and row (2).
• $A2 locks only the column, while the row adjusts as you drag.
• A$2 locks only the row, while the column adjusts as you drag.

Corrected Formula with Absolute References:

If you’re comparing all values in Column B to a fixed baseline in A2, use:

=(B2 - $A$2) / $A$2 * 100

Example:

Baseline Value (A2)	New Value (Column B)	% Change Formula	Result
100	120	(B2 - $A$2) / $A$2 * 100	20%
100	80	(B3 - $A$2) / $A$2 * 100	-20%

Pro Tip: Use a mix of relative and absolute references to make your formulas more flexible when working with large datasets.

Mistake 3: Misinterpreting Negative Results

Negative percentages are a natural outcome of the percentage change formula, but they’re often misunderstood.

A negative result doesn’t mean the calculation is wrong; it just means the value has decreased compared to the baseline.

What It Means

• A negative percentage indicates a decline from the “Old Value” to the “New Value.”
• The greater the negative number, the larger the decrease. For example:
  • -10% means a small drop.
  • -50% means the value was cut in half.

Real-World Scenarios

• Revenue Decline:

Revenue dropping from $500 to $300 shows a -40% change:

=(300 – 500) / 500 * 100 = -40%

• Stock Price Drop:

A stock falling from $150 to $100 shows a -33.33% change:

=(100 – 150) / 150 * 100 = -33.33%

How to Handle It

• Context Matters: Negative results are valuable because they indicate areas of concern or opportunities for improvement.
• Conditional Formatting: Use Excel’s conditional formatting to highlight negative changes in red for better visualization:

• Select your column of percentage changes.
• Go to Home > Conditional Formatting > Highlight Cells Rules > Less Than.
• Enter 0 as the value and choose a red fill color.

Example:

Old Value	New Value	% Change Formula	Result
500	300	(B2 - A2) / A2 * 100	-40%
200	250	(B3 - A3) / A3 * 100	+25%

FAQs About Percentage Change Formula Excel

What is the formula for percentage change in Excel?

The basic formula for percentage change in Excel is:

=(New Value - Old Value) / Old Value * 100

How It Works:

• New Value: The updated or current value.
• Old Value: The original or previous value.
• Multiply by 100 to express the result as a percentage.

Example:

If your sales increased from $500 to $750, here’s how the formula works:

=(750 - 500) / 500 * 100

Result: 50% (a 50% increase).

Pro Tip: Format the result as a percentage in Excel by selecting the cell, navigating to the Home tab, and clicking the % icon.

---

How do I calculate YoY (Year-over-Year) percentage change in Excel?

Year-over-year (YoY) percentage change compares the performance of a metric (e.g., revenue) in one year to the previous year. The formula remains the same but is applied to data organized by years.

Formula for YoY Percentage Change:

=[(This Year’s Value – Last Year’s Value) / Last Year’s Value] x 100

Example:

Year	Revenue ($)	YoY % Change
2023	$1,200,000	–
2024	$1,500,000	(1500000 - 1200000) / 1200000 x 100 = 25%

Step-by-Step:

1. Subtract the previous year’s value from the current year’s value.
2. Divide the difference by the previous year’s value.
3. Multiply by 100 to express the result as a percentage.

Pro Tip: Use an IFERROR formula to handle blank or zero values in your dataset:

=IFERROR((B2 – A2) / A2 * 100, "N/A")

This prevents errors and keeps your sheet clean.

---

Can Excel calculate percentage changes automatically?

Yes, Excel can calculate percentage changes automatically, especially when working with formulas and dynamic datasets. Once you set up your formula, Excel will automatically update the results if the source data changes.

How to Set It Up:

1. Write the formula for percentage change in the first cell (e.g., = (B2 - A2) / A2 * 100).
2. Drag the formula down to apply it to all rows in your dataset.
3. If your dataset is updated (e.g., with new values), Excel will recalculate the percentage change automatically.

Pro Tip: Use absolute references if your formula depends on a fixed baseline value (e.g., $A$2), so it doesn’t shift when dragged across rows or columns.

---

How do I handle datasets with negative numbers?

Negative numbers can appear in your data, especially when dealing with financial losses or stock price drops. Excel’s percentage change formula will handle negative numbers correctly, but the results might need careful interpretation.

How the Formula Works with Negative Numbers:

If your Old Value or New Value is negative, the formula remains the same, but the result may reflect a larger percentage change due to the direction of the shift.

Example 1: Positive to Negative

If a company’s revenue dropped from $500 to -$200, here’s the calculation:

=(-200 – 500) / 500 * 100

Result: -140% (a 140% decline, indicating a complete loss and further debt).

Example 2: Negative to Positive

If revenue went from -$300 to $100, here’s the calculation:

=(100 – -300) / -300 * 100

Result: -133.33% (technically a large gain relative to the negative starting point, but still in debt).

Tips for Handling Negative Numbers:

1. Context is Key: Interpret negative results carefully to understand whether they indicate gains or losses relative to the baseline.
2. Visualization: Use conditional formatting to highlight positive changes in green and negative changes in red for better clarity.
3. Avoid Division by Zero: If your Old Value is zero, use an IFERROR formula to replace the result with “N/A” or “0”.

Optimizing Percentage Change Calculations with Excel and Wisesheets

Percentage change is one of those things that seems way more complicated than it actually is.

At its core, it’s just about figuring out the “how much” behind the “what.”

How much did sales grow? How much did your stock portfolio take a hit? How much did revenue shift between quarters?

These are clues, trends, and answers to the questions that matter in your work.

And the beauty is, Excel makes this ridiculously simple. You don’t need to be a data wizard or have a financial analyst on speed dial.

With a formula as straightforward as = (New Value - Old Value) / Old Value * 100, you can turn a pile of numbers into clear, actionable insights.

But the real challenge isn't the math. It's the process.

Tracking down data, keeping it up to date, and making sure your formulas aren’t riddled with errors – that’s where things can get messy.

And that's exactly where Wisesheets can help you out.

It is not here to replace Excel; it is here to help you make the most of it.

Need live financial data? Wisesheets has you covered.

Want to pull historical stock prices without spending hours Googling? Done.

At the end of the day, percentage change is less about the numbers and more about the decisions that you make with them.

And with the right tools – Excel and Wisesheets – you can tell a story.

A story about growth, progress, and where to go next.

So go on. Turn your data into something that works for you.

Tame the chaos, skip the busywork, and get straight to the insights that matter.

You're more than ready for this.

Master Percentage Change in Excel with Wisesheets