Article ID: 214078 - View products that this article applies to.
This article was previously published under Q214078
In Microsoft Excel, there is no built-in function to calculate the percentage of change from one value to another. However, you can use the following formula to calculate the percentage change
=(new_value-original_value)/ABS(original_value)where original_value represents the value that the percentage of change is based on, and new_value represents the value that has changed.
You may also use the following alternate formula:
=(new_value/original_value)-1To display the resulting value as a percentage value, format the cell containing the formula with a percentage format.
To see an example, follow these steps: