Forum Discussion
Basic subtraction bug/error in Excel
A basic subtraction leads to an erroneous result. please see the screenshot below. @MicroSoftexcel Please confirm if you are also facing the same. I tried in 2 systems both giving same b...
See Floating-point arithmetic may give inaccurate results in Excel
Since your input in A1 and A2 has at most 4 decimal places, round the result of the formulas to 4 decimal places.
In B3: =ROUND(A1-A2, 4)
In B4: =ROUND(A1-A2-A3, 4)