This simply means moving the decimal place two columns to the right. The percent change formula is used very often in Excel. When the new value is greater then the old value it is a percentage increase otherwise it is a decrease.
Then divide that result by the old value.
Formula to Calculate Percentage Change Percentage Change can be defined as a change in value due to changes in the old number and new number and the values can either increase or decrease and so the change can be a positive value or a negative value -. The number after of is always the whole. Partwhole 100 final outcome 210100 20. Percentage change b - a a For example if your earnings are 1250 in January and 1750 in February the percentage change in February compared to January can be calculated in Excel by typing the following formula into any cell of your spreadsheet.