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

    • Marvqn1
    • By Marvqn1 10th Jul 17, 8:57 AM
    • 357Posts
    • 253Thanks
    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
    • 2,544 Posts
    • 1,393 Thanks
    • #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,303 Posts
    • 1,579 Thanks
    • #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
    • 10,069 Posts
    • 7,553 Thanks
    • #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

187Posts Today

1,168Users online

Martin's Twitter
  • I've decided my weekend starts here while the sun's glow is still baskable. So I'm signing off. Have a great weeke?

  • No not correct. The big six do, but you can get fixed tariffs guaranteed not to rise and about 25% cheaper. Just tr?

  • Baaaa! Scottish Power has bleated and followed the herd, today announcing it's putting up energy prices by 5.5%. R?

  • Follow Martin