https://bugs.freedesktop.org/show_bug.cgi?id=70251
--- Comment #3 from Tomaz Vajngerl <[email protected]> --- Andrew: Comparing with <> or = can always be problematic because of rounding error. You can avoid this if you round you result. You have a maximum of 2 digits so if you round the result to 2 digits then it will work. Change the formula to =IF(ROUND(C21-F21;2)<>I21;"ERROR "&(C21-F21-I21);"OK") -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
