Excel calculation shows different value.

Copper Contributor

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.

1 Reply

@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...

https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision...

 

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

image.png