https://bugs.documentfoundation.org/show_bug.cgi?id=134168
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|NEW |RESOLVED
--- Comment #3 from Eike Rathke <er...@redhat.com> ---
Not a bug.
There is accumulated inaccuracy in the results you can see when applying the
General format instead of 0.00, it already starts at G6 132.025 (which itself
is correct but maybe unexpected by you) and G7 148.1882 and G8 148.834150943396
... the visual value 147.91 is in fact 147.908396164021 so multiplying that
with 147 of course gives 21742.5342361111
You need to round the calculations as desired, here 2 decimals, so in G6
=IF(E6<0;G5;ROUND((G5*SUM(E$5:E5)+F6*E6)/SUM(E$5:E6);2))
and copy down.
Either that, or activate "Precision as shown" under Tools -> Options -> Calc ->
Calculate, which is more expensive though and maybe undesired for other
formulas.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
