SUM function bad math

[MrDeath]

The problem with my Excel is that I noticed a sum function that gave a clearly incorrect answer. The sum function (red) adds the yellow and blue values, which anyone with 3rd grade math knows is 257.7. However, the result of the function is 253.3 in the red box.

The yellow and blue boxes are summing many rows of numbers themseves, perhaps that has something to do with it?

Help! It's very difficult to work with Excel when I can't trust the results of the functions I run.

http://i91.photobucket.com/albums/k2...sc/problem.jpg

[NBVC]

It'd it be easier to diagnose if we saw the actual workbook...

Are you sure that your autocalcs is on... Tools|Options and in Calculation Tab, Automatic should be checked.

[shg]

Format some additional decimals in AB6 and look at the value.

[NBVC]

Yes, I bet it is actually about 126.6....

[MrDeath]

Ah ha! shg that is it! I'm working off of an excel doccument someone else created and I didn't think of that, great catch!