Spreadsheet failures, any recent examples? [Software]

posted by Ohlbe – France, 2020-12-10 18:43 (131 d 17:12 ago) – Posting: # 22125
Views: 2,372

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.


Complete thread:

 Admin contact
21,419 posts in 4,475 threads, 1,510 registered users;
online 11 (1 registered, 10 guests [including 4 identified bots]).
Forum time: Wednesday 12:55 CEST (Europe/Vienna)

In the Middles Ages the lingua franca of science was Latin.
Nowadays the language of science is bad English.    Anonymous

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