=SUM problems in totalling figures

[the-chosen-one]

Hi There,

Im new here and wonder if u guys can help.....I have excel from offic
97 and have found a problem when doing a simple column totallin
function

What happens is this.....the previous column im referring to is arrive
at by multiplying a quantity in a previous column by a price in the nex
column...
ie 1 x £2.82 = obviously £2.82 This works no problem, However when
try to total up all the columns, say 15 sum totals,.... I have produce
a
=sum(O6:035) cell at the bottom of all the rows to give me a gran
total but it never adds them up correctly, instead of the answer bein
say 21.56, it tells me its 21.54, which i know to be incorrect afte
using my own calculator...
ive tried all sorts but it wont get it right.

What wrong or what am i doing wrong please???

cheer

 

[Simon Lloyd]

Welcome to The Code Cage!Why not upload
dummy workbook so we can see your problem and help you directly wit
that
Attatchments.

To upload a workbook, click reply then add your few words, scroll dow
past the submit button and you will see the Manage Attatchments button
this is where you get to add files for upload, if you have any troubl
please use this link or the one at the bottom of th
any page.
Or you can check out the video how to 'here
(http://www.thecodecage.com/forumz/helpvideos.php

Hi There

Im new here and wonder if u guys can help.....I have excel from offic
97 and have found a problem when doing a simple column totallin
functio

What happens is this.....the previous column im referring to is arrive
at by multiplying a quantity in a previous column by a price in the nex
column..
ie 1 x £2.82 = obviously £2.82 This works no problem, However when
try to total up all the columns, say 15 sum totals,.... I have produce
a
=sum(O6:035) cell at the bottom of all the rows to give me a gran
total but it never adds them up correctly, instead of the answer bein
say 21.56, it tells me its 21.54, which i know to be incorrect afte
using my own calculator..
ive tried all sorts but it wont get it right

What wrong or what am i doing wrong please??

cheer

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Dave Peterson]

Try showing more decimal places in all the cells.

Maybe data that looks like:
1.23
is really
1.2349999

If you have a few of these, your sum may not look like it matches.

J.E. McGimpsey explains it and offers a solution:
http://mcgimpsey.com/excel/pennyoff.html