SOLVED

New Contributor

# 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

3 Replies

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

Thank you for the link! I don't understand if this behavior is a bug or not?
best response confirmed by i_klemeshov (New Contributor)
Solution

# Re: 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.