Forum Discussion
Two different numbers are identified as same in Excel
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.
The 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?”
2 Replies
The 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?”
Hey HansVogelaar, I can understand why Excel behaves like this now.
Thank you very much for your reply and the link!
