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
- Put the old value in A2 and the new value in B2.
- In C2, type
=(B2-A2)/A2and pressEnter. - Select C2, then on the Home tab click the % button in the Number group (or press
Ctrl+Shift+%on Windows,Control+Shift+%on Mac). - Optionally click Increase Decimal to show more decimals.
- 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
Dividing by the new value instead of the old one. The formula must be
(new-old)/old; dividing by B2 gives a wrong result (20/100 = 20% instead of 25%).Forgetting the parentheses.
=B2-A2/A2divides first and returns 99 for 100 and 80 instead of 0.25. Always write=(B2-A2)/A2.Seeing 0.25 instead of 25%. The cell just isn't formatted as a percentage; click the % button. Don't multiply by 100 and then also apply Percentage format, or you'll get 2500%.
Getting #DIV/0! when the old value is 0 or blank. Wrap the formula in
IF(A2=0,"",...), since a percentage change from zero isn't defined.
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.
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
- Excel IF Formula With Multiple Conditions (With Examples)
- How to Fix the #N/A Error in Excel (Causes and Fixes)
- How to Use SUMIF in Excel (With Examples)
- How to Concatenate Strings in Excel (With Examples)
- How to Delete a Git Branch (Local and Remote)
More Excel questions · All questions · Just Fucking Prompt It