Excel calculation shows different value.

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

@Kannanvenkatraman , that's by design, so called floating point calculation error




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



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