Poradnik Excela

How to Calculate Percentage Change in Excel

Calculating percentage change is essential for tracking growth or decline over time. This guide shows you how to apply the (New-Old)/Old formula in Excel.

Zrób to z SI

Krok po kroku

1
Enter your data
Input your 'Old Value' in cell A2 and your 'New Value' in cell B2.
2
Input the formula
In cell C2, type the formula =(B2-A2)/A2 and press Enter.
3
Format as percentage
Select cell C2, go to the 'Home' tab, and click the '%' icon in the 'Number' group.

=(New-Old)/Old

Wskazówki

Ensure your old value is not zero to avoid a #DIV/0! error.
You can increase decimal places using the 'Increase Decimal' button in the Number group.

Najczęstsze pytania

Why do I get a negative result?

A negative result indicates a decrease from the old value to the new value.