Home

Excel calculation shows different value.

Kannanvenkatraman
Occasional Visitor

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
Highlighted

@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

 

Related Conversations
Question One: Protect Format & Two: Formula
Richard_James in Excel on
0 Replies
Excel question.
skbp1970 in Excel on
6 Replies
Assigning True and False values in IF statements
Blake_Begley in Excel on
2 Replies
Hyperlinks and Objects in Excel for shared files
Bluhe in Excel on
0 Replies