Forum Discussion
Excel changing value
Hi Tania,
That's the nature of floating point operations, see more at https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/ and you may find other articles.
To correct, round all intermediate calculations (that's what usual practice for accountants who use Excel) like
=ABS(ROUND((H24+H23)/2,3)-ROUND((N24+N23)/2,3))
Hi Tania,
That's the nature of floating point operations, see more at https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/ and you may find other articles.
To correct, round all intermediate calculations (that's what usual practice for accountants who use Excel) like
=ABS(ROUND((H24+H23)/2,3)-ROUND((N24+N23)/2,3))
THANK YOU!!!!! :)
now it makes sense!
i will modify my formulas
Tanks you very much for the quick answer
Tania, you are welcome
