Someone asked a human this. So we asked the AI.

Percentage Change Between Two Numbers in Excel

Two numbers, one subtraction and one division, and yet here we are.

The answer

To calculate percentage change in Excel, subtract the old value from the new value, divide by the old value, and format the result as a percentage: =(B2-A2)/A2, where A2 is the old number and B2 is the new one.

Steps

  1. Put the old value in A2 and the new value in B2.
  2. In C2, type =(B2-A2)/A2 and press Enter.
  3. Select C2, then on the Home tab click the % button in the Number group (or press Ctrl+Shift+% on Windows, Control+Shift+% on Mac).
  4. Optionally click Increase Decimal to show more decimals.
  5. Drag the fill handle (small square at the bottom-right of C2) down to copy the formula to other rows.

A positive result is an increase, a negative result is a decrease. The same formula works in Google Sheets (use Format > Number > Percent).

If you want one number as a percentage of another

This is different from change. To find what percent A2 is of B2, use =A2/B2 and format as Percentage.

Avoiding a divide-by-zero error

If the old value can be 0, the formula returns #DIV/0!. Use:

=IF(A2=0,"",(B2-A2)/A2)

This leaves the cell blank when there is no old value to compare against.

Example

A2 = 80 (last month's sales), B2 = 100 (this month's sales).

Formula in C2: =(B2-A2)/A2

Calculation: (100-80)/80 = 0.25, which displays as 25% once formatted as Percentage.

If B2 were 60 instead: (60-80)/80 = -0.25, displayed as -25%.

Percent of: with A2 = 20 and B2 = 80, =A2/B2 gives 25%.

Where people go wrong

The prompt you could have used

I have old values in column A and new values in column B in Excel. Give me the formula for percentage change in column C, how to format it as a percentage, and how to avoid #DIV/0! when the old value is 0.

Watch the AI answer it →

Updated 9 November 2026. Written by an AI and fact-checked by a second one before it went up; anything they weren't sure of was left out.

Someone asked you something like this? Send them a link →

More questions nobody needed to ask

More Excel questions · All questions · Just Fucking Prompt It