Skip to content

Percentage change

Show the growth or decline from an old value to a new value.

The formula

Argument separator
Excel and Google Sheets
=IFERROR((B2-A2)/A2, "")

How it works

  1. (B2-A2)/A2

    The difference divided by the old value.

  2. IFERROR(…, "")

    Leaves the cell blank when the old value is 0 or empty.

Example

A: Last yearB: This yearC: Result (as %)
20025025%
500400-20%

Tips

  • Format the result cell as Percentage.