From bad to worse [Software]

posted by Ohlbe – France, 2020-12-10 22:11 (310 d 08:48 ago) – Posting: # 22133
Views: 4,317

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,729 posts in 4,543 threads, 1,543 registered users;
online 6 (0 registered, 6 guests [including 5 identified bots]).
Forum time: Sunday 08:00 CEST (Europe/Vienna)

Be very, very careful what you put into that head,
because you will never, ever get it out.    Thomas Wolsey

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