In this article we will learn about how to calculate percentage 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.
- 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.
- The function will return total change.
- Copy the formula by pressing the key CTRL+C on your keyboard and paste in the range D4:D13 by pressing the key CTRL+V on your keyboard.
Note: Fix the cell reference by pressing the key F4 on your keyboard. The effect of this after fixing the cell reference is that it stays the same while the relative reference get changes.