Forum Discussion

Kannanvenkatraman's avatar
Kannanvenkatraman
Copper Contributor
Apr 06, 2019

Excel calculation shows different value.

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 ...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 06, 2019

Kannanvenkatraman , 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/

 

You may round your figures or in options Set precision as displayed (be careful with it to avoid side effects)