Really weird decimal amounts

Hi I was disturbed with a very strange small decimal amounts (0.0000000000011) somehow added "from the sky" to the result of my formulas . The problem started from the cell highlighted in red i...

Excel error.xlsx13 KB

excel

IngeborgHawighorst
Jan 10, 2018
Hello,

this probably is caused by the floating point precision issue. Read up about that here:

https://blogs.office.com/en-us/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/

IngeborgHawighorst

MVP

Jan 10, 2018

Hello,

this probably is caused by the floating point precision issue. Read up about that here:

https://blogs.office.com/en-us/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/

Detlef_Lewin

Silver Contributor

Jan 10, 2018

Or watch the video with the ever eloquent Tom Scott.

"And at that point, they will have started to learn about floating point numbers and they will be starting to tear their hair out." OUCH!

Forum Discussion

Really weird decimal amounts

Resources