From bad to worse [Software]

posted by Ohlbe – France, 2020-12-10 23:11 (830 d 09:38 ago) – Posting: # 22133
Views: 6,974

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:

UA Flag
Activity
 Admin contact
22,546 posts in 4,721 threads, 1,608 registered users;
22 visitors (0 registered, 22 guests [including 8 identified bots]).
Forum time: 08:50 CET (Europe/Vienna)

Science is the great antidote to the poison
of enthusiasm and superstition.    Adam Smith

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