Forum Discussion
Tania Bélisle
Aug 20, 2018Copper Contributor
Excel changing value
Hello, i am using excel 2013 on a "excel 1997-2003" spreadsheet. i have a simple formula with a simple result. result should be 3 decimals or 4, cant be any more. yet i notice that excel didnt ...
- Aug 20, 2018
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))
Tania Bélisle
Aug 20, 2018Copper Contributor
THANK YOU!!!!! :)
now it makes sense!
i will modify my formulas
Tanks you very much for the quick answer
SergeiBaklan
Aug 20, 2018Diamond Contributor
Tania, you are welcome