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

Microsoft Excel

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"?

Log in or sign up to see answer

Become an EE member today7-DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform

or

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.

Not exactly the question you had in mind?

Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.

ask a questionGet an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

You guys are complete geeks. Thanks for the help!

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes

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