Forum Discussion

szilvia_vf's avatar
szilvia_vf
Brass Contributor
Aug 25, 2022
Solved

is this a bug or a feature? - adding values, result is wrong when last reference is 0

Hi, I want to report a bug I've just encountered. (file uploaded)   summary of the bug: two relevant columns, one is the rolling sum of the other. Solved by cell references. The formula wo...
  • PeterBartholomew1's avatar
    Aug 25, 2022

    szilvia_vf 

    It is just a fact of life that floating point calculations are not exact.  That is because the binary representations of decimal numbers introduces an error when it is truncated to a fixed length.  That means any test for equality must allow some tolerance. 

     

    If you multiply by 100 and work with integers the calculations will be exact, though you would have to forgo division.