Bug! a very simple substraction shows wrong result (Excel 2010)

[tony567]

Wow, i think i found a bug

try this very simple substraction:

=11.11-11

on my computer the result is 0.109999999999999

another:

=13.71-13 -----> 0.710000000000001
=31.15-31 -----> 0.149999999999999
etc....

please let me know if you got same result. thank you

 

[VoG]

It isn't a bug, it is the inherent imprecision of floating point arithmetic.

 

[mikerickson]

Its called round off error. It comes from the conversion from decimal to binary never being exact.
Every piece of software on every computer experiences this. How many decimals out it begins may vary, but it's always there.

 

[tony567]

ooops, sorry to early name it as a bug

anyway, i want to retrieve only the decimal number

i try A1-TRUNC(A1) but got that result. any suggestion for a precise result?

my decimal is not more than 4 decimal digit.

 

[VoG]

Try

=ROUND(A1-TRUNC(A1),4)

 

[tony567]

Try

=ROUND(A1-TRUNC(A1),4)

Thanks a Lot VoG... result as what i want