the decimals extends after the sum function

H

hou

when I use the Sum function to calculate about 10,000 numbers, which have
been rounded to 2 decimals (using the round function in excel), the result of
sum came out with more than 2 decimals. It is eight decimals!
I don't know why, and I split the numbers into several groups. I find that
an interesting thing, the sum of Group A has two decimals, the same with
Group B. But when I calculate the sum of the two groups, the result also came
out with 8 decimals!!!...
 
J

JoeU2004

hou said:
when I use the Sum function to calculate about 10,000 numbers, which have
been rounded to 2 decimals (using the round function in excel), the result
of
sum came out with more than 2 decimals.

The short answer is: you need to round the sum to 2 decimal places as well.

I find that an interesting thing, the sum of Group A has two decimals,
the same with Group B.

Just a coincidence. In fact, even those numbers are probably not accurate
to 2 decimal places. It just appears that way.

I don't know why

In general, numbers with decimal fractions cannot be represented exactly
because of the way that Excel (and most applications) do arithmetic on
binary computers. For more information, you might look at
http://support.microsoft.com/kb/78113 .


----- original message -----
 
B

Bernard Liengme

I would very much like to see the data. Could you email me a file? Please
get my email from my website
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top