Excel is saying zero is not equal to zero

Question

I have two formulas one that works and one that doesn't.

The following formula works.

M28 cell value = 1192481.00
M28 cell formula = =SUM(M6:M27)
=IF(M28=1192481,TRUE,FALSE).

This accurately returns TRUE as 1192481.00 is equal to 1192481.

The following however does not work.

N28 cell value = 0
N28 cell formula = =SUM(N6:N27)
=IF(N28=0,TRUE,FALSE).

This returns FALSE.

When I click the "Evaluate Formula" button on the Formulas tab of Excel. The value of N28 is displayed as -8.00355337560177E-11. How can I repair this and why is this happening?

Answer 1

It is a floating point error. Increase the decimals for your value and you can clearly see it. I hope this helps you.