Percentage Change Formula in Excel

Percentage Change Formula in Excel

Use of percentage is quite common in our day to day professional activities and keeping this fact in consideration, MS Excel provides an excellent support to this feature.

To have a better understanding of this feature, follow the example below:

A Sugar Mill is processing 1000 matric ton of sugar cane on weekly basis. The day wise data provided by the processing department is as follows:

Sugar Mill is processing

Now, to calculate the percentage of daily achieved target with regards to actual Daily assigned target, type the following code in cell E2

cell E2

To convert the output to percentage format, click on Percentage Style under the Number group in Home tab.

Percentage Style

This will convert the results into percentage format.

85per

The calculated percentage shows 85% production as of assigned daily target.

Now, drag and apply the formula from Cell E3 to E6

Cell E3 to E6

This will apply the formula to selected cells.

selected cells

In stage 2, we will calculate the overall achievement on daily basis. For this, apply following formula on Cell F2

Cell F2

To convert the output to percentage format, click on Percentage Style under the Number group in Home tab.

click on Percentage Style

This will convert the results into percentage format.

17per

The calculated percentage shows 85% production as of assigned daily target.

Now, drag and apply the formula from Cell E3 to E6

formula from Cell E3 to E6

This will apply the formula to selected cells.

formula to selected cells

This example shows the calculations the percentage of daily production as well as its comparison against the overall target.

calculations the percentage

Search

Shortcodes Ultimate

 
Follow Us
 
BGP