Excel 2016 doesn't show true zero

Question

When I sum E2 to H2 in I2, I get 0.00000000000023... Values were entered directly and not formula results. I tried different values and some return true zero and others do not. Any ideas how to fix this to get true zero for all values.

Answer 1

You are running into one of the limitations of the binary expression of decimal numbers.

If you are expecting to only use two decimal places, then be explicit in your formula:

=ROUND(SUM(values),2)

Also, and this can be a further source of error so it is more a curiosity

=Positive Number + Positive Number + Positive Number + Negative Number

will often work and give exactly 0, where this will fail to give exactly 0:

=Positive Number + Negative Number + Positive Number + Positive Number

Answer 2

Since you fail to mention how the cells are formatted its all guesswork