Forum Discussion

Terence Wiggett's avatar
Terence Wiggett
Copper Contributor
Sep 25, 2017

totaling excel sheet

I am having trouble with my excel sheet not totalling up correctley.

If i use autosum or input a formular the total sum is always a few pence out. I have checked with a calculator and excel is out. How do i correct this

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Terence,

     

    Perhaps the format you applied to cells show you rounded figures. To check select cells you sum and apply General format (select them->Ctrl+1->Number->General)

Resources