ROUND function

[MindaugasBacius]

Hei,

How does the ROUND function is working?

I do expect this to turn to 40.2

While this 40.25 - rounds according to my knowledge 🙂

Please anybody explain.

Thank you guys.

[tresB · Accepted solution]

Hi @MindaugasBacius , this is related to binary number system that we should be careful of when dealing with floating point comparisons or so. Read it here : Rounding Errors

[MindaugasBacius]

I did read the article. And will have to read it 10 times more to digest this way of thinking 🙂

[tresB]

🙂 - I agree