Sum Formula Error
I open a text file in comma delimited, and then try to run a sum of 600+
lines. The following is returned -1.86825E-10 and the formula is written as
=SUM(E1:E648)
If I remove the E1 and enter E2, my sum will be the opposite of E1. This
file is a General Ledger integration, so basically the number should be zero,
and this is what I am trying to verify. The column format is General. Does
anyone have any suggestions on why it does this?
Any help you can provide would be greatly appreciated.
Thanks!
|