Forum Discussion
Simple formula shows the decimal value (1,0995-1 = 0.0994999... )
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.
- 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.
