From bad to worse [Software]

posted by Ohlbe – France, 2020-12-10 22:11 (129 d 18:05 ago) – Posting: # 22133
Views: 2,331

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,419 posts in 4,475 threads, 1,510 registered users;
online 12 (0 registered, 12 guests [including 5 identified bots]).
Forum time: Monday 17:17 CEST (Europe/Vienna)

There is one certainty in drug development
and statistics that one can depend on:
the data are always late.    Scott Patterson and Byron Jones

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