Percentage change calculator
Calculate percentage change and copy the Excel formula. Enter the old and new values. This page does not use the AI generation quota.
Result
25.00%
=IF(B2=0,"",(C2-B2)/B2)
Put the old value in B2 and the new value in C2, then format as Percent.
The Excel formula
=(new-old)/old with old in B2 and new in C2 is =(C2-B2)/B2. Guard a zero old value with =IF(B2=0,"",(C2-B2)/B2). Format the cell as Percent.
How to use this calculator
01
Enter the old value
This is the starting number, such as last month revenue in B2.
02
Enter the new value
This is the later number, such as this month in C2.
03
Read the result
The page shows the percent change as a number.
04
Copy the Excel formula
Paste =(C2-B2)/B2 into Excel and format as Percent.