Home Page
   Articles
       links
About Us    
Traders        
Recipes            
Latest Articles
excel fault with sum function

 
Post new topic   Reply to topic    Downsizer Forum Index -> IT Matters
Author 
 Message
Lorrainelovesplants



Joined: 13 Oct 2006
Posts: 6521
Location: Dordogne
PostPosted: Sat Apr 25, 15 10:39 am    Post subject: excel fault with sum function Reply with quote
    

Im sitting doing accounts like I do every year, and have been trying to reconcile one month. Its on an excel spreadsheet and for some reason I cannot get it to add up correctly. Have been checking on the calculator and the sum function appears to be rounding up.

Can I override this?

So - Im adding a column and the total is being computed as 1698.4, but its actually (and Ive checked this 3 times) 1698.37.
the next column is the same - computer says 1005.6, but its 1005.58

Pilsbury



Joined: 13 Dec 2004
Posts: 5645
Location: East london/Essex
PostPosted: Sat Apr 25, 15 10:46 am    Post subject: Reply with quote
    

Shoild be an option to display to 2 decimal places or smetimes it lets you format the cells as £ and thst automatically displays as 0. 00

Lorrainelovesplants



Joined: 13 Oct 2006
Posts: 6521
Location: Dordogne
PostPosted: Sat Apr 25, 15 10:56 am    Post subject: Reply with quote
    

cant see where?

Lorrainelovesplants



Joined: 13 Oct 2006
Posts: 6521
Location: Dordogne
PostPosted: Sat Apr 25, 15 10:58 am    Post subject: Reply with quote
    

found format and changed from general to accountancy, 2 decimal places. Recalculated - same. grrr.

bagpuss



Joined: 09 Dec 2004
Posts: 10507
Location: cambridge
PostPosted: Sat Apr 25, 15 1:36 pm    Post subject: Reply with quote
    

That sounds like you need to go to 4 decminal places

If 1005.58 is in fact 1005.587 it might still be rounding up

edit:The other option is rounding elsewhere in the spreadsheet

Lorrainelovesplants



Joined: 13 Oct 2006
Posts: 6521
Location: Dordogne
PostPosted: Sat Apr 25, 15 2:27 pm    Post subject: Reply with quote
    

sorted.....
managed to do the 2 decimal places thing and then another problem appeared, but a friend in Glasgow said make the column wider... .

all better now.

Still hate computers.

Nick



Joined: 02 Nov 2004
Posts: 34535
Location: Hereford
PostPosted: Sat Apr 25, 15 2:51 pm    Post subject: Reply with quote
    

Should we change the thread title to reflect the fact that there was no fault with Excel?

Lorrainelovesplants



Joined: 13 Oct 2006
Posts: 6521
Location: Dordogne
PostPosted: Sat Apr 25, 15 2:58 pm    Post subject: Reply with quote
    

dont be mean.....
Not my fault Im not computer friendly.....
My ageing brain just seems to have reached capacity....

Post new topic   Reply to topic    Downsizer Forum Index -> IT Matters All times are GMT
Page 1 of 1
View Latest Posts View Latest Posts

 

Archive
Powered by php-BB © 2001, 2005 php-BB Group
Style by marsjupiter.com, released under GNU (GNU/GPL) license.
Copyright © 2004 marsjupiter.com