Hướng dẫn Excel

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.

Để AI làm thay

Từng bước

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

Mẹo

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.

Câu hỏi thường gặp

Why do I get a negative result?

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