Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Incorrect Sum
I am having a problem summing a column of numbers. These numbers are both
negative and positive numbers. When I sum the numbers it comes to zero. This is correct, but when I reformat and take out a 30 decimal places I suddenly start getting numbers starting at about the 12th decimal place. These numbers are dollar amounts. I know they don't go beyond 2 decimal places. I've hand entered them. When I take all of the numbers out 30 decimal places, nothing shows up. It only does it on the sum. I tried summing only the negative numbers and postive numbers separately it works then, but I can do it this way for what I need to do. I've tried a bunch of things. Thanks Bill |
#2
|
|||
|
|||
Take a look at Chip Pearson's discussion why this happens:
http://www.cpearson.com/excel/rounding.htm And look at J.E. McGimpsey's workarounds: http://www.mcgimpsey.com/excel/pennyoff.html ashlandpmac wrote: I am having a problem summing a column of numbers. These numbers are both negative and positive numbers. When I sum the numbers it comes to zero. This is correct, but when I reformat and take out a 30 decimal places I suddenly start getting numbers starting at about the 12th decimal place. These numbers are dollar amounts. I know they don't go beyond 2 decimal places. I've hand entered them. When I take all of the numbers out 30 decimal places, nothing shows up. It only does it on the sum. I tried summing only the negative numbers and postive numbers separately it works then, but I can do it this way for what I need to do. I've tried a bunch of things. Thanks Bill -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ACCRINT formula gives incorrect result | Excel Worksheet Functions | |||
After installing SP1 for XL2003 Subtotals show incorrect result | Excel Discussion (Misc queries) | |||
Incorrect Japanese guidance with Excel 2003 | Excel Worksheet Functions | |||
In Excel 2003, the histograms are incorrect. Excel shows a bar gr. | Excel Discussion (Misc queries) | |||
Help Excel97 gives incorrect multiplication response | Excel Worksheet Functions |