Archive for Downsizer For an ethical approach to consumption
 


       Downsizer Forum Index -> IT Matters
Lorrainelovesplants

excel fault with sum function

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

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

cant see where?
Lorrainelovesplants

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

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

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

all better now.

Still hate computers.
Nick

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

dont be mean.....
Not my fault Im not computer friendly.....
My ageing brain just seems to have reached capacity....
       Downsizer Forum Index -> IT Matters
Page 1 of 1
Home Home Home Home Home