Excel cant count or I am crazy!
Using Excel 2003, if I sum the following numbers :
I get a result of -2.30556906899437E-10!! I have copied them into notepad, and then copied them back in to clear all formatting, but I am still getting this bizarre result? I have tried them in different spreedsheets, I have manually inputted them.
Last edited by StevenAFC; 01-02-2009 at 08:49 AM.
The joys of rounding errors in excel and the conversion between binary and decimal!
it should be 0, and is nearly that! You have to emply rounding somewhere in the calculations!
Yes Excel can count, and no you're not going crazy, just not interpreting what you're seeing. The sum of those numbers is zero. On my Mac it actually shows as zero, but it's not surprising that on some PCs it's displaying what you say - which is simply the best way it can find of telling you it's a very small number i.e.
I suspect one or more of those numbers are actually the result of a calculation, and because of the finite level of accuracy in any computer there is actually a very small residual number left when you add them up. You can prove this by using an =ROUND(A1,2) function. Put this in the adjacent column to your numbers and copy down, then sum this column. I'll be surprised if you don't get a big fat zero.
Well I am glad I am not crazy, I had already tried rounding the numbers, but unfortunatly it still doesnt work. But as long as I know its not me its fine, ill just have to Round the totals to make it work.
Obviously rounding the total will work fine, but It seems strange, and I'm somewhat intrigued, to hear that you've rounded all the individual numbers and the unrounded total still shows as a small residual decimal. Do you want to upload the actual workbook so that we can take a look?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1