Excel CAN'T ADD!

[ccalleri]

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!

 

[maccompaq]

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!

I used your figures in Excel and come up with 50.83.

 

[firstapple]

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:

 

[Gerg]

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.

 

[MacDawg]

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

 

[herr_neumann]

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....

 

[MacDawg]

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....

Did you report your issue to MS, and if so, did you get a response?


Woof, Woof - Dawg

 

[BashBrannigan]

check cell references

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

 

[herr_neumann]

Did you report your issue to MS, and if so, did you get a response?


Woof, Woof - Dawg

I filled out their online feedback form on the mactopia page, but I have heard nothing since.

-J