[Solved] Simple sum is wrong

[linz]

i have used tried a simple calculation but it seems to be adding up wrong its 1p out

£5.46 + £21.34 + £0.71 = should be £27.51 but it keeps giving me £27.52
spreadsheet attached

[Hagar Delest]

Hi and welcome to the forum!

This is due to the display of rounded numbers.
They display with 2 digits as:
£5.46
£21.34
£0.71
However, the true value is (increase the number of digits):
£5.460
£21.344
£0.713
Thus leading to £27.517, rounded to... £27.52.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the 🖉 button if your issue has been fixed.

[Zizi64]

There is an option in the LO Calc - Calculate settings: "Precision as shown".
You can try it.

...I never use it.

[linz]

is there any way to change it so it adds up to the ignoring all the other decimal places? so the answer is £27.52?

[robleyd]

Use ROUND() on your calculations to limit the values to two decimals. For example in F18 use:

Code: Select all

=ROUND(B18 * D18; 2)

[Zizi64]

is there any way to change it so it adds up to the ignoring all the other decimal places? so the answer is £27.52?

You can ROUND the operands and/OR the results.

Or you can use the "Precision a shown" option for the Calc application.

[Hagar Delest]

You can ROUND the operands and/OR the results.

My 2 cents: round each detail line, thus the result will show the exact sum of the lines.
If you round the result only and someone sums each line then he can complain that there is a discrepancy.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the 🖉 button if your issue has been fixed.