Forum Discussion
Simple formula shows the decimal value (1,0995-1 = 0.0994999... )
Hello, encountered incomprehensible behavior with simple calculation in Excel.
For visibility for the cell you need to choose a numerical format with a discharge of 20. The formula looks like this: =1,0995-1 The result is: 0.09949999999999999999999999999999999999999
If the cell format is chosen as the same, then the formula 1.0995-1 will show 0.0995. But if this result is copied and pasted into another cell as a number, it will still be 0.099499999999999999999999999
Office 2013. The problem also manifests itself in 2007, 2016! It happens in any cell and in any book and on different PC
i_klemeshov , that's a nature of binary calculations. Same way or another we have that in any software, another story how concrete application handles floating point errors.
Consider that as a bug or as a feature - up to you. That's just what we have to know about Excel, the thing which always will work such way. As well as year 1900 will always be considered in Excel as leap one.
3 Replies
- Thank you for the link! I don't understand if this behavior is a bug or not?
i_klemeshov , that's a nature of binary calculations. Same way or another we have that in any software, another story how concrete application handles floating point errors.
Consider that as a bug or as a feature - up to you. That's just what we have to know about Excel, the thing which always will work such way. As well as year 1900 will always be considered in Excel as leap one.
