https://issues.apache.org/ooo/show_bug.cgi?id=124613
bmarcelly <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #11 from bmarcelly <[email protected]> --- I am not a math expert, still I know that... - conversion from decimal to floating point representation cannot always be exact - the precision of a Double precision number is equivalent to about 15 or 16 decimal digits in decimal representation - any floating point calculation can add errors. As a consequence : Testing if two floating point numbers are equal is a non-sense! Because of inherent errors you should instead do something like =IF(ABS(A6-A12)<0.0000000001;"Balanced";A6-A12) Further reading : Floating point article in Wikipedia https://en.wikipedia.org/wiki/Floating_point What Every Computer Scientist Should Know About Floating-Point Arithmetic http://docs.oracle.com/cd/E19957-01/806-3568/ncg_goldberg.html -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
