D
doug9238
I have had no luck figuring this out...
I have a list of 8 positive and negative numbers that 2 decimal place
each. The numbers sum to zero confirmed by a calculator, however exce
sums them to (2.55654899E12). I do not know why excel calculates the
with a small value left that is denoted by scientific notation.
I checked the value of each number to ensure that it did not includ
any extra decimals, and I even re-typed them.
I have had this happen with several other lists of numbers that are n
brainers to calculate, and excel added extra scientific notation to th
total.
I have no idea why this happens, and I am starting to lose confidenc
in excels formulas.
Any help would be appreciated.
Doug Micoliche
I have a list of 8 positive and negative numbers that 2 decimal place
each. The numbers sum to zero confirmed by a calculator, however exce
sums them to (2.55654899E12). I do not know why excel calculates the
with a small value left that is denoted by scientific notation.
I checked the value of each number to ensure that it did not includ
any extra decimals, and I even re-typed them.
I have had this happen with several other lists of numbers that are n
brainers to calculate, and excel added extra scientific notation to th
total.
I have no idea why this happens, and I am starting to lose confidenc
in excels formulas.
Any help would be appreciated.
Doug Micoliche