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
    • 345Posts
    • 222Thanks
    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
    • 2,146 Posts
    • 1,089 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,146 Posts
    • 1,512 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,796 Posts
    • 7,295 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

207Posts Today

1,153Users online

Martin's Twitter
  • RT @LordsEconCom: On Tuesday Martin Lewis, Hannah Morrish & Shakira Martin gave evidence to the Cttee. Read the full transcript here: https?

  • Ta ta for now. Half term's starting, so I'm exchanging my MoneySavingExpert hat for one that says Daddy in big letters. See you in a week.

  • RT @thismorning: Can @MartinSLewis' deals save YOU cash? ???? https://t.co/igbHCwzeiN

  • Follow Martin