How to Calculate Percentage Change in LibreOffice Calc

This quick guide explains the steps to calculate the percentage change in any direction in LibreOffice Calc.

Percentage change calculation is a common task you generally do for any data item. And it’s very easy to do it LibreOffice Calc.

Calculate Percentage Change

For example, you have below sales data per month for a year.

Monthly Change Formula
Monthly Change Formula

Now, if you want to calculate the month-on-month sales change in percentage, you have to use a basic formula. 

To calculate month-wise change, in cell C3 write below:

=(B3-B2)/B2

You can see the change is calculated in decimal value. Now, select the calculated value in C3 and click on the % icon in the toolbar to convert it to percentage. 

Then drag the cell handle until C13 for the entire data range.

Monthly Change
Monthly Change

You can see that the cell formula is changed in each cell as per default relative reference

If you want to calculate total percentage change over the starting value, you can write below formula in cell D3:

=(B3-$B$2)/$B$2
Total Change
Total Change

Then drag the cell handle down till the last data item in the range. You can also notice that the value of B2 didn’t change until the last cell due to the absolute reference

SEE ALSO:  How to Zoom In, Zoom out in LibreOffice Calc Sheet

This way you can easily create the percentage change in LibreOffice calc.


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Related

Support Us


Be an expert on LibreOffice.

Small and quality tutorials. Delivered. Thrice a week.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back to top