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