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.

Done.

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

This is the missing link I was looking for….

Thanks!!!

Manrico.

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

I think maybe you’re not formatting the answer cell properly.

Try: 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.

Even better!! https://percentagecalculator.net/