Discussion in 'Mac Apps and Mac App Store' started by ccalleri, Mar 22, 2008.

1. ### ccalleri macrumors member

Joined:
Jul 7, 2007
Location:
Toronto
#1
Check out this problem I am having .. what is the deal??
The top number has the =sum formula .. IT'S OFF BY 0.01!

If you take a calculator and add up the column, you get 50.83 NOT 50.82!

File size:
14.7 KB
Views:
527
2. ### maccompaq macrumors 65816

Joined:
Mar 6, 2007
#2
I used your figures in Excel and come up with 50.83.

3. ### firstapple macrumors 6502a

Joined:
Sep 25, 2007
#3
Same here... there may be a rounding issue if you have input more then 2 decimals when entering numbers. Excel works fine, I have never had an issue with it calculating anything wrong, and I use it 5 days a week for 40+hours.

I would say check all the values being summed, and see if anything accidentally has more then two decimals.

For instance: If you have ten "\$0.001's" they will display \$0.00 however when you SUM them it will give you a total of \$0.01:

4. ### Gerg macrumors regular

Joined:
Feb 3, 2003
#4
That's usually the case, one of the numbers has more than 2 digits after the decimal, but the formatting only shows 2. It may also be the case that one of the numbers listed is a calculation of something else (or rather, the result of another calculation) and has been rounded to 2 decimal places.

5. ### MacDawg macrumors Core

Joined:
Mar 20, 2004
Location:
"Between the Hedges"
#5
Also, you can go into your preferences and "set precision as displayed" and it will take care of the issue, although you will lose the accuracy from the non-displayed decimals.

Woof, Woof - Dawg

6. ### herr_neumann macrumors 6502

Joined:
Mar 27, 2003
Location:
Roseville, Ca
#6
I ran into some issues with the normdist function while doing some financial modeling, so Excel is not flawless. Actually with the number of firms that use Excel Microsoft should be going through that code with a fine tooth comb, it would be ironic to see them done in by I banks that have used their software instead of a tech company....

7. ### MacDawg macrumors Core

Joined:
Mar 20, 2004
Location:
"Between the Hedges"
#7
Did you report your issue to MS, and if so, did you get a response?

Woof, Woof - Dawg

8. ### BashBrannigan macrumors newbie

Joined:
Mar 23, 2008
Location:
Toronto
#8
check cell references

Could be rounding off, but something tells me it might also be the sum formula isn't referencing all the cells.

9. ### herr_neumann macrumors 6502

Joined:
Mar 27, 2003
Location:
Roseville, Ca
#9
I filled out their online feedback form on the mactopia page, but I have heard nothing since.

-J