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 the formula =SUM(B2:C2). Then, F has the formula =IF(E2=D2,TRUE,FALSE), but some vales get FALSE response although it's actually true. You can check an example file here: https://1drv.ms/x/s!AjwgDFM7OKYTg49igQBc9XR3mXppAQ?e=pvZfWy
Thanks in advance for the help.
3 Replies
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
