Hi,

I thing that larger errors by users are responsible for the world economic
crisis, and if they had used Excel properly they might have gotten an
inkling of what could happen to them. Really, these number are off in the
14th or 15th decimal place - 0.000000000000034

not

5,000,000,000,000 (5 trillion dollars)

A lot of people bought houses far beyond theirs means and not by
$.0000000000003, more like $100,000.

Cheers,
Shane Devenshire

"abracadabra" wrote in message
...
very strange behavior of if function resulting in wrong result which might
be
a bug.
try it out at your own, and try other values just remember the same
difference.

a1=300 b1=303,6 c1=b1-a1 d1=3,6 e1=if(c1<=d1;"OK";"NOT OK")

the result of e1 should be "OK" but its "NOT OK"

a1=200 b1=203,6 c1=b1-a1 d1=3,6 e1=if(c1<=d1;"OK;"NOT OK")

the result of e1 is "OK"

What the hell is going on ? It does not help to format the cell's.
Have i found a bug, and if it is i will call it a MAJOR BUG which could be
the reson of world economic crisis ;o)