Feb 02 2021 02:28 AM
Hi Guys,
Recently I encountered an issue like the subject title says.
See the attached file for details:
A1 and B1 contain different number, but C1 (=A1=B1) displays as TRUE and D1 (= A1-B1) shows as 0.00
Is this a bug of Excel? Any help is welcome.
Feb 02 2021 02:41 AM
SolutionThe numbers differ in the 15th digit; this is right at the limit of Excel's precision, so you cannot rely on the result.
See for example Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?”
Feb 03 2021 03:02 AM
Hey @Hans Vogelaar, I can understand why Excel behaves like this now.
Thank you very much for your reply and the link!
Feb 02 2021 02:41 AM
SolutionThe numbers differ in the 15th digit; this is right at the limit of Excel's precision, so you cannot rely on the result.
See for example Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?”