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 but erroneous result.
The right answer should be '0' ZERO.
1 Reply
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)
