rodynetwork

asked on

# Excel sheet calculation problem

See the attached sheet. When I select column C, the sum is 5.68434E-13. Why? The sum should be zero. Normally I can click on C and it will give an accurate sum. What do I need to address? 51003EE.xls

ASKER

Hi Barry,

Ket me clarify what I am asking. I have for several years now simply clicked on the C column and the sum of that column appears at the bottom of my window. That always works and it is always accurate. A few days ago something happened where I import a few lines of data and every since then the C column has that weird " 5.68434E-13" instead of the actual number. Here's another wierd thing: if I delete a row, it will sum correctly. Any row, not just a particular row, but delete any row and the sum works. Ok, now that I am articulating this, I think I may realize what you are saying....are you saying the weird " 5.68434E-13" is excels way of saying "zero"?

Ket me clarify what I am asking. I have for several years now simply clicked on the C column and the sum of that column appears at the bottom of my window. That always works and it is always accurate. A few days ago something happened where I import a few lines of data and every since then the C column has that weird " 5.68434E-13" instead of the actual number. Here's another wierd thing: if I delete a row, it will sum correctly. Any row, not just a particular row, but delete any row and the sum works. Ok, now that I am articulating this, I think I may realize what you are saying....are you saying the weird " 5.68434E-13" is excels way of saying "zero"?

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

You guys are complete geeks. Thanks for the help!

That amount is a number very close to zero, the reason it isn't zero is to do with the way Excel calculates - it can sometimes result in small "precision errors". You can get the correct sum in a cell by rounding e.g.

=ROUND(SUM(C:C),9)

regards, barry