Your browser isn't supported
It looks like you're using an old web browser. To get the most out of the site and to ensure guides display correctly, we suggest upgrading your browser now. Download the latest:

Welcome to the MSE Forums

We're home to a fantastic community of MoneySavers but anyone can post. Please exercise caution & report spam, illegal, offensive or libellous posts/messages: click "report" or email forumteam@. Skimlinks & other affiliated links are turned on

Search
  • FIRST POST
    • Marvqn1
    • By Marvqn1 10th Jul 17, 8:57 AM
    • 311Posts
    • 198Thanks
    Marvqn1
    LibreOffice Calc Sum?
    • #1
    • 10th Jul 17, 8:57 AM
    LibreOffice Calc Sum? 10th Jul 17 at 8:57 AM
    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?
Page 1
    • Le_Kirk
    • By Le_Kirk 10th Jul 17, 9:31 AM
    • 1,899 Posts
    • 957 Thanks
    Le_Kirk
    • #2
    • 10th Jul 17, 9:31 AM
    • #2
    • 10th Jul 17, 9:31 AM
    Could be rounding errors. What format have you applied to each cell and to the cell where the total and the formula resides?
    • bengalknights
    • By bengalknights 10th Jul 17, 9:32 AM
    • 4,043 Posts
    • 1,479 Thanks
    bengalknights
    • #3
    • 10th Jul 17, 9:32 AM
    • #3
    • 10th Jul 17, 9:32 AM
    Change the formatting to 8dp and see if shows a difference on numbers
    • GunJack
    • By GunJack 10th Jul 17, 10:20 AM
    • 9,601 Posts
    • 7,163 Thanks
    GunJack
    • #4
    • 10th Jul 17, 10:20 AM
    • #4
    • 10th Jul 17, 10:20 AM
    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......
Welcome to our new Forum!

Our aim is to save you money quickly and easily. We hope you like it!

Forum Team Contact us

Live Stats

2,728Posts Today

8,261Users online

Martin's Twitter
  • Byebye! I'm about to stop work & twitter, to instead spend glorious time with Mrs & mini MSE. Wishing u a lovely summer. See u in 10 days.

  • WARNING Did you start Uni in or after 2012? The interest's rising to 6.1%; yet it doesnt work like you think. See https://t.co/IQ8f0Vyetu RT

  • RT @JanaBeee: @MartinSLewis Boris is the anomaly (coffee), the others are versions of normal (beer). Lots of same candidates = vote share d?

  • Follow Martin