Bug in sum formula for Excel versions 97 - 2002

B

Ben

I have found a 'bug' in the sum formula.
Cell A1 type 1065.33
Cell B1 type 1005.33
Cell C1 type 60
Cell D1 type =sum(A1-C1)
the result in D1 will be 1005.33
Cell E1 type =sum(B1-D1)
the sum should be 0, but instead is 1.13687e-13
I have tried this on Excel 97, 2000 sr1, 2002 sp2
Thanks,
Ben
 
D

Dave R.

Ben, if you google search the newsgroup archives for "1.13687e-13" you will
find a post that describes and explains this.
 

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

Similar Threads

Combining several cells into single equasion? 1
If statements 1
formula to add year to date figures 3
will a function do this for me? 1
Funtions return wrong result BUG in Execel ??? 8
Formulas 5
SUMIF function help 4
"Textualize" another cell's formula 4

Top