Simple formula shows the decimal value (1,0995-1 = 0.0994999... )

[i_klemeshov]

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

[#2]

@i_klemeshov 

That's Floating-point arithmetic may give inaccurate result in Excel - Office | Microsoft Docs 

[#3]

Thank you for the link! I don't understand if this behavior is a bug or not?

[#4 · Accepted solution]

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