Spreadsheet failures, any recent examples? [Software]

posted by Ohlbe – France, 2020-12-10 19:43 (788 d 10:12 ago) – Posting: # 22125
Views: 6,841

Dear ElMaestro,

❝ does anyone have recent examples of spreadsheet functions truly misbehaving with real-life realistic data?


A colleague recently pointed to a strange behaviour in Excel (I have 2013, he has 2016, both give the same result here.

Type =0.5-0.4-0.1: you'll get the expected result, 0.

Now type =(0.5-0.4-0.1): you'll get -2,77556E-17. What ? Ain't that supposed to be the same calculation ?

Trying =0=0.5-0.4-0.1: the answer I got was FALSE. WTF, if the answer you get is 0 ? It's not a matter of number of decimals displayed: I tried to add more to the first result, or to switch to scientific notation, but still got 0.

Regards
Ohlbe

Complete thread:

UA Flag
Activity
 Admin contact
22,481 posts in 4,710 threads, 1,603 registered users;
21 visitors (0 registered, 21 guests [including 12 identified bots]).
Forum time: 05:55 CET (Europe/Vienna)

The difference between a surrogate and a true endpoint
is like the difference between a cheque and cash.
You can get the cheque earlier but then,
of course, it might bounce.    Stephen Senn

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