Forum Discussion
Solved
oddest issue I have ever come across
So working on some financial figures. A1 28,179,010.06 B1 14,000,000 C1 12,179,010.06 D1 2,000,000 E1 contains the formula a1-b1-c1-d1. I get zero. However, the cells are formatted for acc...
Since we use decimal numbers and Excel internally uses binary numbers with a finite precision, tiny rounding errors may occur.
Since all your numbers have at most 2 decimal places, you should round the result of the formula to 2 decimal places too:
=ROUND(A1-B1-C1-D1,2)
Since we use decimal numbers and Excel internally uses binary numbers with a finite precision, tiny rounding errors may occur.
Since all your numbers have at most 2 decimal places, you should round the result of the formula to 2 decimal places too:
=ROUND(A1-B1-C1-D1,2)
Thank you. I just changed the formatting to numbers and how negatives will display so that everything looks uniform. Something so minor was driving me nuts. I appreciate you explaining what is going on.