From bad to worse [Software]

posted by Ohlbe – France, 2020-12-10 22:11 (280 d 19:02 ago) – Posting: # 22133
Views: 4,024

Hi fellows,

Sorry guys, but there are some things going back behind the scene, which I really fail to understand.

If I get -2,77556E-17 when I type =(0.5-0.4-0.1), how comes that I get 0 when I type =(-0.1-0.4+0.5) ? The same figures, just in a different order ?

If I get FALSE when I type =0=0.5-0.4-0.1, how comes that I get TRUE when I type =0=-0.4-0.1+0.5 ?

And to be fair to Excel, the same happens in [image]:

0==(0.5-0.4-0.1)
[1] FALSE
0==(-0.4-0.1+0.5)
[1] TRUE


Are they first calculating -0.4-0.1=-0.5, which is nicely binarily coded, then -0.5+0.5=0 ?

Regards
Ohlbe

Complete thread:

Activity
 Admin contact
21,687 posts in 4,534 threads, 1,542 registered users;
online 17 (0 registered, 17 guests [including 4 identified bots]).
Forum time: Friday 18:14 CEST (Europe/Vienna)

Genius is that which forces
the inertia of humanity to learn.    Henri Bergson

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz
HTML5