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
    • 324Posts
    • 210Thanks
    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,986 Posts
    • 1,003 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,074 Posts
    • 1,488 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,644 Posts
    • 7,202 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

4,166Posts Today

9,774Users online

Martin's Twitter