sum not accurate

**MIAO** · 06-15-2012, 02:45 PM

all the data in the excel is less than 2 decimal but the sum/aggregate I calculated is 6 decimals?

Why is that and how do I change it so its 100% accurate to the data I entered.

Thanks

**Steve0492** · 06-15-2012, 02:54 PM

Hello MIAO,

I believe your sum is 100% accurate. Your answer of 892238109.749998 is really 892238109.75, I believe it is just a result of the way Excel calculates things. If you want to get rid of the extra decimals, you can always use the function:

=ROUND(SUM(A1:A45898),2)

Let me know if this helps.

Steve

**MIAO** · 06-15-2012, 03:54 PM

If it's accurate where did 0.0000002 gone? my data set has only 2 decimals.... this can't be random....

**Steve0492** · 06-15-2012, 04:05 PM

This article might shed some light on what I was referring to. Does your task not allow you to use the round function?

http://www.cpearson.com/excel/rounding.htm

**Marcol** · 06-15-2012, 08:23 PM

If you divide 1 (no decimals) by 3 (no decimals) how many decimals do you expect in the answer?

**FDibbins** · 06-15-2012, 08:33 PM

the answer is correct, its the the way that it is being displayed/formatted, tha makes it look that way. in the cell with the sum formula, press F2, the F9, and see what the results are? press escape after you have checked the answer so you dont lose the formula