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)
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)
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?