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
Show Blank or Zero
I_B_C in Excel on
0 Replies
Duplicate Billing
Kay_T1060 in Excel on
0 Replies
formuale help
Gavc1 in Excel on
1 Replies
searching a sheet with a true and false function
Aaron_excel in Excel on
5 Replies
Excel Help - Stacking IF Formulas
MaddieLB in Excel on
2 Replies
Convert string to number of days
arjsharm in Excel on
2 Replies