LibreOffice Calc Sum?

Options
Marvqn1
Marvqn1 Posts: 634 Forumite
First Anniversary Name Dropper First Post Combo Breaker
in Techie Stuff
In LibreOffice Calc, im trying to calculate the total of a column using =sum then dragging the area of the cells that I want to add up.

However, the total displayed is 0.02 less than when I add up the cells manually using a calculator.

How can I calculate the correct total?

Comments

  • Le_Kirk
    Le_Kirk Posts: 22,309 Forumite
    First Anniversary First Post Photogenic Name Dropper
    Options
    Could be rounding errors. What format have you applied to each cell and to the cell where the total and the formula resides?
  • bengalknights
    bengalknights Posts: 5,021 Forumite
    First Anniversary First Post
    Options
    Change the formatting to 8dp and see if shows a difference on numbers
  • GunJack
    GunJack Posts: 11,673 Forumite
    Name Dropper First Anniversary First Post Photogenic
    Options
    rounding on spreadsheets can be a constant source of frustration in these circumstances...always a trade-off between accuracy and having a sensible cell format to be readable. Best play about with dp as suggested above :)
    ......Gettin' There, Wherever There is......

    I have a dodgy "i" key, so ignore spelling errors due to "i" issues, ...I blame Apple :D
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

Categories

  • All Categories
  • 343.2K Banking & Borrowing
  • 250.1K Reduce Debt & Boost Income
  • 449.7K Spending & Discounts
  • 235.3K Work, Benefits & Business
  • 608K Mortgages, Homes & Bills
  • 173.1K Life & Family
  • 247.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 15.9K Discuss & Feedback
  • 15.1K Coronavirus Support Boards