If want to calculate percentage change in Excel this can be done using a simple Excel formula. Increase New Number - Original Numb er. Divide the New Value by the Old Value you will get a decimal number Step 2.
Divide the chosen number by 100.
How to calculate percentage change and percentage formula. To calculate CPI or Consumer Price Index add together a sampling of product prices from a previous yearThen add together the current prices of the same products. Next divide the increase by the original number and multiply the answer by 100. How to Calculate an Index Number.