Excel Formula Percentage Change between Two Numbers

Percentage change tells you how much a number increased or decreased compared with the previous value. It is useful for revenue, traffic, costs, and performance reports. This guide shows the standard formula with a monthly revenue example.

Formula Syntax

Use this base syntax for excel formula percentage change between two numbers and replace the ranges with your own spreadsheet columns. 

(new_value - old_value) / old_value

Need this formula for your exact sheet?

Generate a custom excel formula percentage change between two numbers formula with your own columns, criteria, and spreadsheet layout.

Generate Free Formula

Step-by-step Example

A expense planning spreadsheet tracks Monthly revenue change and needs a formula-driven result instead of manual filtering.

Last Month This Month
10000 12500
8000 7600
15000 18000

Resulting formula

=(B2-A2)/A2

The formula evaluates the Monthly revenue change rows and returns 25%. Replace the sample ranges with your actual columns, then adjust the criteria so the result matches your workbook.

Try It Now

The generator is pre-filled for excel formula percentage change between two numbers. Edit the prompt to match your columns, criteria, and spreadsheet layout.

You can write your request in any language. Excel formula language is selected separately.

Auto (detect from browser)

Available after free registration Sign up free

C

Available after free registration Sign up free

2

Available after free registration Sign up free

Security check required. Please complete the captcha below.

Works with SUMIFS, IF, XLOOKUP, dates, text, arrays…

Generated formula

How it works

Need more formulas every day?

HelpFormula Pro is $7.99/mo for faster spreadsheet work across Excel and Google Sheets.

  • ✓ Higher daily formula generation limits
  • ✓ Saved formula history for reuse
  • ✓ Excel formula language selection
Upgrade to Pro — $7.99/mo Sign Up Free

Common Variations

  • Percentage increase
  • Percentage decrease
  • Handle zero old value

FAQ

How do I set up Excel Formula Percentage Change between Two Numbers for Monthly revenue change?

Map the sample columns to your own sheet first, then replace the formula ranges with the real ranges from your workbook. Keep text criteria in quotes and verify that date or number columns are stored as real values.

Can this formula handle percentage increase?

Yes. Use the same formula pattern and change the criteria, helper column, or lookup value for percentage increase. If the logic becomes more complex, generate a custom version with the free tool.

What should I check if the Excel Formula Percentage Change between Two Numbers result is wrong?

Check that every referenced range covers the same rows, locked references use dollar signs where needed, and the criteria type matches the data. For this page, also confirm that the Monthly revenue change fields are formatted consistently.