I think I found a glitch in SUM formula.

[xArpitx]

So, I'm getting different results from the SUM function of few following Numbers:

C6 1038554.0000000000000000
C7 -1038554.0000000000000000
C8 24130.6500000000000000

Glitched Answer Formula
=SUM(C8,C6:C7) -result-->> 24130.6499999999000000

So, if Anyone could please explain Why the glitched answer is off by 0.0000000001??????

Correct Answer Formula
=SUM(C6:C8) -result-->> 24130.6500000000000000



File Attached

 

[vletm]

xArpitx

Customize Excel and track notes in Outlook—here’s what’s new to Microsoft 365 in November

We’ll continue to innovate across the Microsoft 365 experience, so our customers always have the best tools to navigate an increasingly distributed and fast-paced world.

www.microsoft.com