View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Excel Addition Error

I also get 4,496,180.

How about formatting those cells to sum as General and widening the column.
Maybe some of the decimal portions are hidden (by format or by column width).



dwright wrote:

Open an Excel spreadsheet, format a column as numeric, no decimals, and paste
in the following 8 values:

442,528
1,477,789
17,942
130,714
84,053
524,606
1,724,962
93,586

Sum them. You will get the answer 4,496,179. The correct answer is
4,496,180. I would suggest you incorporate round-off error correction
routines in your math calculations. This is strictly a newbie error, and I'm
frankly amazed that you haven't caught it yet.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


--

Dave Peterson