Excel calculation shows different value.

Question

I have four cells, three cells with values and fourth cell as answer.
A= 0

B= 10200
C= 10200
D= Formula.
When i use formula D= B-C+A, i get

Where did i made mistake?

Kindly help me.

Thanks in advance.

sergeibaklan · Answer

Kannanvenkatraman&nbsp;, that's by design, so called floating point calculation error
https://support.microsoft.com/en-us/help/78113/floating-point-arithmetic-may-give-inaccurate-results-in-excel
https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/
&nbsp;
You may round your figures or in options Set precision as displayed (be careful with it to avoid side effects)

&nbsp;

Forum Discussion

Excel calculation shows different value.

1 Reply