Forum Discussion
Problems with SUM checking
Hello! I'm having trouble with a formula for checking a SUM. In B and C columns there are values (both positive and negative), D column has the result of B+C manually typed (not formula) and E has t...
Excel creates tiny rounding errors in calculations because of the way numbers are stored and processed.
Since your numbers have at most 2 decimal places, you can avoid the discrepancies by rounding the result of the formula to 2 decimal places:
=ROUND(SUM(B2:C2),2)
That's an option, but SUM and typed values should correspond when it has the same value. I'm applying it meanwhile