Excel autosum problem in Excel

Joined
Dec 4, 2014
Messages
1
Reaction score
0
When I autosum a spreadsheet horizontally and autosum the resulting column vertically, it comes to zero (as it should).
When I autosum the same spreadsheet vertically and autosum the resulting row horizontally, I get an error message 9.21E-12 instead of zero.
Any ideas as to what is going on here?
dog.fish
 
Joined
Mar 20, 2012
Messages
764
Reaction score
4
Without seeing the data, or testing it out, I would assume just a rounding issue. You could put a =round(<yourSUMeq here>,0) and it will round 9.21E-12 to 0. 9.21E-12 is the same as 0.00000000000921 (essentially 0).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top