Whether you are analyzing quarterly sales growth, adjusting your advertising budget, tracking investment returns, or simply comparing prices at the grocery store, understanding how to calculate the percent change between two numbers is an essential skill. In business, marketing, and scientific research, relative metrics are almost always more informative than absolute numbers. For instance, knowing that your website traffic increased by 1,000 visitors tells you very little unless you know whether your starting point was 500 visitors or 500,000 visitors.

While the concept of percentage math seems straightforward, many professionals, students, and analysts frequently stumble. They confuse "percentage change" with "percentage difference," or fail to distinguish between "percent" and "percentage points." These errors can lead to deeply flawed reports, incorrect budget projections, and skewed statistical analyses.

In this definitive guide, you will learn exactly how to find the percent change between two numbers under any scenario. We will break down the mathematical formulas, provide step-by-step examples for both increases and decreases, contrast percent change with percent difference, and provide copy-and-paste formulas for Excel, Google Sheets, JavaScript, and Python. Let's dive in.

The Fundamental Difference: Percent Change vs. Percent Difference vs. Percentage Points

To master calculations involving percentages, you must first recognize that "percent change," "percent difference," and "percentage points" are not interchangeable terms. They serve distinct analytical purposes, and using the wrong one can render your data meaningless.

1. Percent Change: The Chronological, Directional Metric

We use the term percent change when we are comparing an earlier value (the "before" or "original" value) to a later value (the "after" or "new" value). It is inherently directional and chronological.

Percent change answers the question: How much did a specific value grow or shrink over time relative to its starting point? Because it is directional, a percent change can be positive (indicating a percent increase) or negative (indicating a percent decrease).

When you want to find percentage change between two numbers, the original value acts as the fixed anchor or baseline for the entire calculation.

• Example scenario: Measuring how your company’s email subscriber list grew from 1,000 subscribers in January to 1,500 in June.

2. Percent Difference: The Non-Directional Peer Metric

Conversely, we use percent difference when we are comparing two numbers that are peer values. In this scenario, there is no chronological order, no direction of change, and neither number is the "original" or "correct" starting point. They are simply two concurrent values of the same type that we want to compare.

If you need to find percentage difference between two numbers, the formula relies on their average rather than a single starting value. Percent difference answers the question: How different are these two independent numbers relative to their average value? Because there is no direction, the result of a percent difference calculation is always expressed as a positive number using absolute values.

If your goal is to get percentage difference between two numbers rather than chronological growth, this is the correct calculation to use.

• Example scenario: Comparing the average house price in Seattle ($850,000) with the average house price in Denver ($600,000). Neither city’s housing market came "first," so we use their average as the baseline.

3. Percentage Points: Comparing Two Percentages

One of the most frequent mathematical errors in professional journalism and business intelligence occurs when comparing two rates that are already expressed as percentages. Analyzing the percentage difference between two percentages can be tricky, and this is where you must understand the difference between a "percent change" and a "percentage-point change".

If you want to find the percentage difference between two percentages, you have two choices depending on your analytical goal:

• Absolute Difference (Percentage Points): If a state's sales tax rate rises from 5% to 7%, the absolute difference is simply 2 percentage points (7% - 5% = 2 percentage points). It is incorrect to say the tax rate increased by "2%".
• Relative Difference (Percent Change): If you want to know the rate of change relative to the baseline, you apply the percent change formula to the percentages themselves. Going from 5% to 7% represents a relative increase of 40% (since 2 is 40% of 5).

Understanding this distinction is vital. If a marketing campaign increases your website conversion rate from 1% to 2%, your conversion rate has increased by 1 percentage point, but it represents a massive 100% relative increase in conversions. Misrepresenting these figures in business meetings can lead to massive misunderstandings.

How to Calculate Percent Change Between Two Numbers: Step-by-Step

Now that we have established the theoretical foundations, let us focus on the practical calculations. To calculate percentage change between two numbers, you must use a formula that isolates the change and compares it directly back to the original starting point.

The Percentage Change Formula

The standard mathematical formula to calculate percentage change between two numbers (an old value V1 and a new value V2) is:

Percent Change = ((V2 - V1) / |V1|) * 100

Where:

• V1 represents the original, old, or starting value.
• V2 represents the new, final, or resulting value.
• |V1| represents the absolute value of the original number (this ensures the math remains correct even if you are dealing with negative numbers, which we will explore in the FAQ).

Let's break this down into three simple, sequential steps that you can perform manually or on a basic calculator to find the difference between two numbers in percentage.

Step 1: Calculate the Absolute Change (Difference)

First, you must calculate the difference between the two numbers. Subtract the original value from the new value:

Difference = V2 - V1

• If the result is positive, you are looking at a percent increase.
• If the result is negative, you are looking at a percent decrease.

Step 2: Divide by the Original Value

Next, take the difference you calculated in Step 1 and divide it by the absolute value of the original value (V1):

Decimal Change = Difference / |V1|

This step scales the change relative to your starting point. It yields a decimal number representing the fraction of growth or shrinkage.

Step 3: Convert the Decimal to a Percentage

Finally, to display the difference between two numbers in percentage format, multiply the decimal change by 100 and add a percent sign (%):

Percent Change = Decimal Change * 100

Real-World Example 1: Calculating a Percent Increase

Imagine you run an online retail store. In November, your website attracted 12,500 unique visitors. In December, during the holiday rush, your traffic surged to 17,250 unique visitors. What was the percent increase in website traffic?

• Identify the variables:

  • Original Value (V1) = 12,500
  • New Value (V2) = 17,250

• Step 1: Find the difference. 17,250 - 12,500 = 4,750

• Step 2: Divide by the original value. 4,750 / 12,500 = 0.38

• Step 3: Multiply by 100. 0.38 * 100 = 38%

Your website experienced a 38% increase in traffic month-over-month.

Real-World Example 2: Calculating a Percent Decrease

Now, let's look at a scenario where a metric shrinks. You are reviewing your business expenses and notice that your monthly cloud hosting bill was reduced from $450 in Q1 to $315 in Q2 after optimizing your database queries. What was the percent decrease in your hosting costs?

• Identify the variables:

  • Original Value (V1) = 450
  • New Value (V2) = 315

• Step 1: Find the difference. 315 - 450 = -135

• Step 2: Divide by the original value. -135 / 450 = -0.3

• Step 3: Multiply by 100. -0.3 * 100 = -30%

Your database optimizations resulted in a 30% decrease in cloud hosting expenses.

How to Find the Percentage Difference Between Two Peer Values

There are many analytical situations where you need to compare two numbers, but neither represents an "old" or "new" value. For example, if you are comparing the revenue of two different company departments, or comparing the pricing of two competing products, you want to calculate the difference percentage between two numbers without implying any direction or order.

To do this, you must calculate the percent difference. Instead of dividing the difference by an arbitrary starting value, you divide it by the average of the two numbers. This gives us the unbiased percentage difference of two numbers.

The Percentage Difference Between Two Numbers Formula

To calculate percent difference between two numbers, or when comparing the percentage difference between two values, use the following percentage difference between two numbers formula:

Percent Difference = (|Value 1 - Value 2| / ((Value 1 + Value 2) / 2)) * 100

Let's break this formula down step-by-step:

1. Calculate the absolute difference: Subtract one number from the other and take the absolute value (ignore any negative sign). This is represented by |Value 1 - Value 2|.
2. Calculate the average of the two numbers: Add the two numbers together and divide by 2. This is represented by (Value 1 + Value 2) / 2.
3. Divide the difference by the average: This scales the difference against a neutral, shared midpoint, helping you find percentage difference between two numbers objectively.
4. Convert to a percentage: Multiply the resulting decimal by 100.

Real-World Example: Peer Comparison

Let's say you are comparing the price of two premium project management software platforms. Platform Alpha costs $24 per user per month, and Platform Beta costs $30 per user per month. You want to understand the percentage difference between 2 numbers to help contextualize the pricing gap for your executive board.

• Identify the variables:

  • Value 1 (A) = 24
  • Value 2 (B) = 30

• Step 1: Find the absolute difference. |24 - 30| = |-6| = 6

• Step 2: Find the average of the two values. Average = (24 + 30) / 2 = 54 / 2 = 27

• Step 3: Divide the difference by the average. Decimal Difference = 6 / 27 = 0.2222

• Step 4: Convert to a percentage. 0.2222 * 100 = 22.22%

The pricing of the two project management platforms differs by 22.22% relative to their average cost.

Why Use the Average Instead of One of the Numbers?

If you had used Platform Alpha as the baseline, the relative increase to Beta would be 25% (6 / 24). If you had used Platform Beta as the baseline, the relative decrease to Alpha would be 20% (6 / 30). By using the average (27), you get a symmetric percentage difference (22.22%) that does not favor either platform as the primary reference point. This is crucial for maintaining objectivity in research papers and competitive market analyses.

Spreadsheet Formulas: Excel and Google Sheets Guide

Manually performing these calculations is fine for isolated examples, but in the professional world, you will almost always need to calculate difference between two numbers inside a spreadsheet. Both Microsoft Excel and Google Sheets make it incredibly easy to automate these formulas across hundreds of data rows.

Let's look at how to set up these calculations cleanly, including how to handle common spreadsheet errors.

1. Calculating Percent Change in Excel / Google Sheets

To find the percentage change over time, place your original value in Column A and your new value in Column B.

• Data Layout:

  • Cell A2: Original Value (e.g., Last Year's Sales)
  • Cell B2: New Value (e.g., This Year's Sales)

• The Formula: Enter the following formula in cell C2: =(B2-A2)/A2

  Alternatively, you can write the simplified algebraic equivalent: =(B2/A2)-1

• Formatting the Result: By default, Excel will display this result as a decimal (e.g., 0.15). To display it as a percentage:

  1. Select cell C2.
  2. Click the Percent Style button (%) on the Home tab (or press Ctrl + Shift + % on Windows, Cmd + Shift + % on Mac).
  3. Adjust the decimal places to show one or two decimal points for precision.

• Handling the Division by Zero Error (#DIV/0!): If your starting value in cell A2 is 0, Excel will return a #DIV/0! error because dividing any number by zero is mathematically undefined. To prevent this from breaking your dashboard, wrap your formula in an IFERROR function: =IFERROR((B2-A2)/A2, 0)

  This formula instructs Excel to return 0 (or you can substitute a text string like "N/A") if the starting value is zero.

2. Calculating Percent Difference in Excel / Google Sheets

If you want to compare two peer cells without implying direction, you must build the percentage difference formula using the ABS and AVERAGE functions.

• Data Layout:

  • Cell A2: Value 1
  • Cell B2: Value 2

• The Formula: Enter the following formula in cell C2: =ABS(A2-B2)/AVERAGE(A2,B2)

• How it works:

  • ABS(A2-B2) calculates the absolute difference between the two values, stripping away any negative signs.
  • AVERAGE(A2,B2) calculates the mathematical mean of the two values.
  • The division operator / divides the absolute difference by the average.

Format cell C2 as a percentage, and your spreadsheet will dynamically calculate the peer-to-peer percentage difference as you update the numbers.

Programmatic Solutions: JavaScript and Python Implementations

If you are building custom software, designing a web-based financial calculator, or writing data analysis scripts, you need to implement these calculations programmatically. Below are clean, production-ready functions in JavaScript and Python that include robust error handling for edge cases.

JavaScript Implementation

In JavaScript, we must be careful with floating-point arithmetic precision and division-by-zero scenarios.

function calculatePercentChange(oldValue, newValue) {
    if (oldValue === 0) {
        return newValue === 0 ? 0 : Infinity;
    }
    return ((newValue - oldValue) / Math.abs(oldValue)) * 100;
}

function calculatePercentDifference(value1, value2) {
    const absoluteDiff = Math.abs(value1 - value2);
    const average = (value1 + value2) / 2;
    if (average === 0) return 0;
    return (absoluteDiff / average) * 100;
}

Python Implementation

For data scientists and backend engineers, Python offers clean syntax. Here is how you can write these functions cleanly, making use of Python’s built-in mathematical operators.

def calculate_percent_change(old_value, new_value):
    if old_value == 0:
        return 0.0 if new_value == 0 else float('inf')
    return ((new_value - old_value) / abs(old_value)) * 100

def calculate_percent_difference(val1, val2):
    absolute_diff = abs(val1 - val2)
    average = (val1 + val2) / 2.0
    if average == 0:
        return 0.0
    return (absolute_diff / average) * 100

Frequently Asked Questions (FAQ)

To help solidify your understanding, let us address some of the most common edge cases, mathematical queries, and real-world scenarios that arise when working with percentage changes and differences.

How do you calculate percent change with negative numbers?

Calculating a percent change when one or both of your numbers are negative can seem counterintuitive. However, the standard formula holds true as long as you utilize the absolute value of the original number in the denominator:

Percent Change = ((V2 - V1) / |V1|) * 100

Let's look at an example. Suppose a struggling business lost $50,000 in Year 1 (expressed as -50,000). Through aggressive cost-cutting, they turned things around and made a profit of $100,000 in Year 2 (expressed as +100,000). What is the percent change?

• V1 = -50,000
• V2 = 100,000

Now, let's plug these into the formula:

1. Find the difference: 100,000 - (-50,000) = 150,000.
2. Divide by the absolute value of the original: 150,000 / |-50,000| = 150,000 / 50,000 = 3
3. Multiply by 100: 3 * 100 = 300%

The company experienced a 300% increase in financial performance. If you did not use the absolute value in the denominator, you would get a negative percentage change (-300%), which makes no sense because their financial performance clearly improved.

Can a percent change be greater than 100%?

Yes. A percent change can easily exceed 100%. A percent change of exactly 100% means that your value has doubled. For example, if you grow your investment from $100 to $200, you have a 100% increase.

If your value grows to more than double its original size, the percent change will be greater than 100%. For example, if your investment grows from $100 to $350, the math works out as: ((350 - 100) / 100) * 100 = 250% increase

There is no upper limit to a percent increase. However, a percent decrease cannot exceed 100% unless you are dealing with negative values. If a physical object loses 100% of its weight, value, or mass, it reaches zero. You cannot lose more than 100% of a positive quantity without dipping into negative territory (such as a bank account balance).

What is the difference between percent change and percentage points?

This is the single most common reporting error in business and journalism. To reiterate:

• Percent Change measures the relative rate of growth or contraction. It is always calculated relative to a baseline value.
• Percentage Points measure the absolute arithmetic difference between two percentages. You calculate it simply by subtracting one percentage from another.

For example, if a website's conversion rate goes from 10% to 15%:

• The percentage point change is an increase of 5 percentage points (15% - 10% = 5).
• The percent change is an increase of 50% (because the conversion rate grew by half of its original value of 10%).

What should I do if the original value is zero?

If your original value is zero, calculating a percent change is mathematically impossible because division by zero is undefined. In business reporting, if you go from 0 sales in Month 1 to 10 sales in Month 2, there is no valid percentage growth. In these situations, analysts typically:

• Report the absolute growth (e.g., "+10 sales").
• Use a footnote or a placeholder like "N/A" (Not Applicable) in reports.
• Shift the baseline to a non-zero starting point (e.g., measuring quarterly instead of monthly).

How do retail platforms calculate price discounts?

Retailers use a specific variation of the percentage decrease calculation to show discounts. This is often programmed into a price difference percentage calculator on e-commerce sites.

The math compares the MSRP (List Price) to the Sale Price:

Discount Percentage = ((List Price - Sale Price) / List Price) * 100

For example, if an electronics store sells a smart TV for $700 instead of its normal list price of $1,000, the markdown is: ((1,000 - 700) / 1,000) * 100 = 30% Off

Conclusion

Understanding how to calculate the percent change between two numbers is more than an academic exercise; it is a foundational skill for data literacy in the modern world. By clearly separating percent change (which measures chronological growth or shrinkage) from percent difference (which compares peer values objectively), you ensure your data reports are mathematically accurate and intellectually honest.

The next time you prepare a business presentation, write a research paper, or build a financial model, keep this guide handy. Use the step-by-step formulas, rely on the Excel tips to automate your spreadsheets, and make sure you never confuse a relative percentage increase with an absolute percentage point change. Armed with these techniques, you can confidently analyze and present numerical trends with perfect mathematical precision.