How to calculate a percentage increase using the OpenOffice spreadsheet

Here is an example of how to calculate a percentage increase/decrease in an OpenOffice spreadsheet (calc).

In the cell window enter “=(C5-B5)/B5” and hit enter. The result window (D5) will display the percentage increase from old number (B5) to new number (C5).

In this case 752-565/565= 33.10%

The formula is, the new number minus the old number divided by the old number.

Keep in my mind the result cell (D5 in this example) must be formatted for percentage. To do this, select the cell, right mouse click, select format cell, select percentage.


I got tired of Googling this every time. There’s probably an easier way to do it, but this one works for me.

Share this:


  1. Gail says:

    When I use your formula with the ” – I get this “=(F27-E27)/E27” but how do I get the percentage? If I take out the ” I get =(F27-E27)/E27 I get #VALUE!

    It’s much easier doing formulas in Excel….I can’t seem to get them to work in OO.

    Any help you can give me would be greatly appreciated. I like the way you explained it above

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.