Subtract the original value from the new value. To calculate the percent change in excel we need at least two numbers from different time periods. Just right-click on a cell that contains a decimal or a row or column full of such cells and select Format Cells.
Percentage Difference in Excel is used to find the percentage changes ups and downs and also percentage value of any number.
Excel offers us multiple configuration options. The percentage increase between September and October is 25 with this figure shown as a decimal number 025 by default in Excel using the formula above. Percentage Change Formula The percentage between the two values is simply calculated by taking the difference between two numbers and dividing it with the original number. The formula new_value-old_valueold_value can help you quickly calculate the percentage change between two numbers.