Percentage sum returns incorrect result

Hi all,

I am trying to add cells containing percentages but I am not getting the correct result. I am totally baffled by this! I have checked the format of the cells: all are correctly formatted in percent format with 2 decimals.

As you can see in the screenshot below, the values and formula are listed correctly but the result is incorrect.

It would be greatly appreciated if someone could tell me what I am doing wrong.


Please check adding more decimals. I bet you have something like “-0.3743%” and “0.0987%” giving sum of “-0.2756%”, and when you only show two decimals, they all round to what you see.

Thank you Mike. You were correct. Is there a way to force Calc to only use 2 decimals?

Personally I would advise to use explicit rounding (using ROUND function and friends) where you need it. However, there is a setting doing what you want: OptionsLibreOffice CalcCalculate[x] Precision as shown under “General Calculations”.

Awesome! Thank you very much for your help Mike.