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

--- Comment #6 from Mike Kaganski <[email protected]> ---
(In reply to Kevin Suo from comment #5)
> A1:  243,362.83

This means that Ai internally *already* has exactly this number:
243362.82999999998719431459903717041015625

> A2: -243,362.84

And A2 has
-243362.83999999999650754034519195556640625

> A4: = DECIMAL2(A1) + DECIMAL2(A2)
> A4 returns -0.01 rather than -0.01000000000931.

No, A4 returns exactly
0.01000000000931322574615478515625

And I asked also what is in a cell with '=DECIMAL2(A1)'.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to