Floating point arithmetic, again [Software]

posted by ElMaestro  – Denmark, 2020-12-10 22:38 (1204 d 13:46 ago) – Posting: # 22130
Views: 8,625

Hi Ohlbe,


❝ Mmmm. But then if the problem comes from the nasty 0.1, how comes that if I type =(0.8-0.4-0.2-0.1-0.1) I get a nice 0, without any funky E-17 ? And then if I type =0=(0.8-0.4-0.2-0.1-0.1), or =0=0.8-0.4-0.2-0.1-0.1 I get a nice TRUE ?


Impossible to tell if this is an effect from Excel or from some degree of streamlining within the CPU.
It is fairly trivial (I think) at the CPU level as well as in Excel to check if you are handing objects of the type (x-x) and to substitute those with a zero where they occur.

Pass or fail!
ElMaestro

Complete thread:

UA Flag
Activity
 Admin contact
22,957 posts in 4,819 threads, 1,636 registered users;
107 visitors (0 registered, 107 guests [including 10 identified bots]).
Forum time: 12:25 CET (Europe/Vienna)

With four parameters I can fit an elephant,
and with five I can make him wiggle his trunk.    John von Neumann

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