Question: how to calculate the percentage deviation?
Answer: The percentage of deviation is calculated by subtracting the old value from the new value, and then dividing the result by the old one. The result of calculating this formula in Excel should be displayed in the percentage format of the cell. In this example, the calculation formula is as follows (150-120) / 120 = 25%.