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.
Cheers
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: Options▸LibreOffice Calc▸Calculate▸[x] Precision as shown under “General Calculations”.
Awesome! Thank you very much for your help Mike.
