From bad to worse [Software]

posted by Ohlbe – France, 2020-12-10 22:11 (85 d 07:36 ago) – Posting: # 22133
Views: 1,789

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]:

[1] TRUE

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


Complete thread:

 Admin contact
21,370 posts in 4,463 threads, 1,495 registered users;
online 17 (0 registered, 17 guests [including 3 identified bots]).
Forum time: Saturday 05:48 CET (Europe/Vienna)

If debugging is the process of removing bugs,
then programming must be the process of putting them in.    Edsger W. Dijkstra

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