The Okopochini Bug

[David Okopochini]

Type (in a column) these numbers into MS Excel 2002 with SP2 applied &
see what answer you get (I think this should work within any version
of excel but don't quote me).

799.06
-525
-179.19
-47
-43.51
-4.36

Select the summation (Sigma) icon to add the numbers together.
Answer = -5.06262E-14 when it should be zero!

Why's that? mmmmmmm. The Okopochini Bug has arisen!

Regards

David Okopochini

 

[Rchard]

Seems to work that way in Excell 2000 also.

 

[Rchard]

Format the cell to a number and it will show the answer
you want.