Doesn't Add Up

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    10 years, 6 months ago

    Hi Bob,

    thanks for your question, and sorry for the trouble.

    Do you mean that weird 6.600000000001 value where you probably expect 6.60? The reason for this simply is how numbers are stored digitally (so-called floating point arithmetic), where things like this can happen.
    I suggest to simply add rounding to the formula in that last row, i.e. a formula like

    =ROUND( SUM( B2:B8 ), 2 )

    Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Doesn't Add Up’ is closed to new replies.