Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Addition Error
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing Violation Error while opening Excel file with Win Runner | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel Error Message | Excel Worksheet Functions | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
error opening excel file | Excel Worksheet Functions |