Hi,

Does anybody know why in Excel2000 the

(0.09+0.01-0.1) = -1,38778E-17

while

0.09+0.01-0.1 = 0 (as taught in schools)

The same error you get with (0.09+0.01)-0.1.

I checked it in on Intel Celeron 400MHz and Pentium IV with on two operation systems: W2K and W98. Seems to be Excel bug.

I found it incementing a Double variable in VBA.

Does anybody know how to get rid of that?

Thanks in advance

Valdi