From bad to worse [Software]

posted by Ohlbe – France, 2020-12-10 22:11 (146 d 00:45 ago) – Posting: # 22133
Views: 2,498

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,444 posts in 4,482 threads, 1,509 registered users;
online 4 (0 registered, 4 guests [including 2 identified bots]).
Forum time: Wednesday 23:57 CEST (Europe/Vienna)

Only dead fish go with the current.    Scuba divers' proverb

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