By Shivani Garg
You can use the percent change formula in Excel. Percent change can be used to calculate the Monthly , Yearly & Total Change.
Let's learn with example
Here we will calculate the Yearly Percentage change in sales of company A
>> Select cell C5 and enter the formula =(B5-B4)/B4
>> Press enter , you will get the value as
>> Select cell C5. On the Home tab, Apply Percentage Format. Or you can press (Ctrl+Shift+%)
(Ctrl+Shift+%) is shortcut to apply percentage format
Result will be
>> Now, Select cell C5, click on the lower right corner and drag it down to cell C11.
Like this way, you can calculate the percentage change .
Let's look at a new example.
Here we will calculate the percent change of marks of students or you can say we will calculate percent change in two values.
>> Select cell D2 and enter the formula =(C2-B2)/B2
>> Press enter , you will get the value as
>> Select cell D2 On the Home tab, Apply Percentage Format.
>> Now, Select cell D2, click on the lower right corner and drag it down to cell D11.
And the Result will be
Likewise you can calculate any Percent Change you want.
Related >>
Labels:
MS Excel
Shivani Garg