Bug in sum formula for Excel versions 97 - 2002

  • Thread starter Thread starter Ben
  • Start date Start date
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
 
Ben, if you google search the newsgroup archives for "1.13687e-13" you will
find a post that describes and explains this.
 
Back
Top