 # Percent Change Formula in Microsoft Excel

The percent change is a universal formula for percentage change. Percentages are stored as decimal value in Microsoft Excel.

For Example 15% is stored as 0.15 and 75% is stored as 0.75 etc.

So you can convert to numbers into percentage, Either go to Home tab, in the Number group click on % icon or by press the key Ctrl+Shift+%(5) on your keyboard. How to calculate percent change in Microsoft Excel?

Let’s take an example and understand how you can change the number in percent.

We have yearly production data range A1 to B13. Column A contains years, Column B contains Sales Amount. In Column C we wants to calculate the yearly change and in column D total change. To calculate percentage  follow below mentioned steps and formula:

• Select the cell C3 and write the formula to return the yearly change.
• =(B3-B2)/B2
• Press enter on your keyboard.
• The function will return the yearly change in numbers.
• Copy the formula by pressing the key CTRL+C on your keyboard and paste in the range C4:C13 by pressing the key CTRL+V on your keyboard. To convert the numbers into percentage select the range C3:C13 and press the key Ctrl+Shift+%(5).

In the similar way we can calculate the total change.

This time we have to fix the reference to cell B2, follow below mentioned steps:-

• Select the cell D3 and write the formula to calculate the total change.
• =(B3-\$B\$2)/\$B\$2 and press enter key on your keyboard.
• Press Enter on your keyboard. 