For example one how to calculate the percentage change. First calculate the difference between new and old. If the result is negative then it is a decrease.
Subtract old value from new value.
If the answer is a negative number that means the percentage change is a decrease. Percent Change New Value Old Value Old Value. To calculate the percent change in excel we need at least two numbers from different time periods. Below is the formula to calculate the percent change in general.