Excel 2013 - Same calculation gives different result

Question

I have the same formulas giving different results

The cell values are shown above and the formulas below

5344.850000000000000000000000	5344.850000000000000000000000
5344.850000000000000000000000	5344.850000000000000000000000
0.000000000000000000000000	0.000000000000000000000000
0	-0.0000000000009094947017729280
TRUE	FALSE

5344.85	5344.85
5344.85	5344.85
0	0
=A1-A2-A3	=B1-B2-B3
=A4=0	=B4=0

Office 2013

Answer 1

Hello, 

this is an example of Excel floating point calculations. Excel cannot use more than 15 significant digits in numbers.

For more details read  

Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?”

Answer 2

I'm  showing more than 15 digits not using more than 15.

The number is 5344.85 that would be 5 significant digits.

Answer 3

Sorry for not making it clearer but cells A1:B5 are displayed with values and their formulas

the calc is 5344.85-5344.85-0 it is as simple as that and I get two different results.

Answer 4

Excel's floating point math only explains a portion of this issue.  Most likely some or all of the cells A1,A2,B1 and B2 contain formulas!  And we can't see those formula only their apparent results.  

Excel does not return a floating point error with exactly identical data.  So there must be underlying formulas in at least one of the cells A1:B2.

Unrelated:  You can download a free Excel Olympic Database at 

bit.ly/SDOlympics