Wrong sum result

[leprince2007]

Dear all,

Could you help to solve my problem,please?
I have some values positive and negative but their Sum result is "-2.8421709430404E-14" but the wright answer is zero
Why this number is shown?How to fix it?
See the attachment

[Glenn Kennedy]

See here:

https://support.microsoft.com/en-gb/...sults-in-excel

Solution: round your results to the appropriate level of precision, which looks like 2 DP.

[Special-K]

If you renter the SUM() formula in the same cell B34 - or just select B34 press F2, hit return - it works.

If you copy the numbers to a different column then enter the SUM at the bottom of the new column - it works.
Also reentering the numbers manually in another column - it works.

[leprince2007]

MR,Glenn Kennedy .I found the solution in your link:
Change format to "Number"
But why Excel shows this number instead of zero?

[MrShorty]

As explained in Glenn's link, it is due to floating point error -- an inherent part of how computer's do arithmetic. If you feel Glenn's link did not explain it adequately, perhaps one of my links will help: https://www.excelforum.com/groups/ma...nd-errors.html

[leprince2007]

ok thank you all