Calculate the percent increase or decrease from an old value to a new one.
Copy this formula
=(B2-A2)/A2Subtract the old value from the new value, then divide by the old value. Format as Percentage. A positive result is growth; a negative result is a decline.
=(150-120)/120→25%Sales grew 25% from 120 to 150.
Guard against divide-by-zero
=IF(A2=0, "", (B2-A2)/A2)Returns blank when the old value is 0.
Apply a custom number format like +0.0%;-0.0% to force the sign.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.