https://bz.apache.org/ooo/show_bug.cgi?id=126992
Andrea Pescetti <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Andrea Pescetti <[email protected]> --- If it helps, the precision problem is not related to ABS() here as the following formula (here represented in Italian for the user's convenience) is broken too: =SE(A2-A1 <= 0,01; "TRUE"; "FALSE") (expected: TRUE; reported: FALSE) On the other hand, if this helps the user for this specific issue, =SE(A2 <= A1 + 0,01; "TRUE"; "FALSE") will give TRUE as expected; so you can probably work around this by rewriting your formula as follows: =SE(E(A2 <= A1 + 0,01; A1 <= A2 + 0,01); "TRUE"; "FALSE") The two are equivalent in theory, but decimal numbers in Calc are almost always approximated so this explains the apparent contradiction. -- You are receiving this mail because: You are the assignee for the issue.
