[Libreoffice-bugs] [Bug 138595] calc ROUND() precision bug

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Dec 4 13:54:25 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=138595

--- Comment #5 from beckyomegakawaii at gmail.com ---
Hello, sorry for the late reply. Here's an explanation.

C38, Employee earns THB51 per hour, and has worked for 56 hours. Results in
EXACTLY 2856.00
N38, Employee earns 1.5 times the normal working hour for
overtime,(51*1.5=76.5). Has worked for 13 hours. Results in EXACTLY 994.50
Q38, Total employee earning, 2856.00+994.50 = EXACTLY 3850.50
R38, 57.00 subtracted from total earnings
S38, Net earning, is 3850.50 minus 57.00. Results in EXACTLY 3793.50

I don't see anywhere that any rounding errors could accumulate?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201204/ac0b59ae/attachment.htm>


More information about the Libreoffice-bugs mailing list