SOLVED

Two different numbers are identified as same in Excel

New Contributor

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.

 

 

2 Replies
Best Response confirmed by Boying (New Contributor)
Solution

@Boying 

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 @Hans Vogelaar, I can understand why Excel behaves like this now.

Thank you very much for your reply and the link!