Spreadsheet failures, any recent examples? [Software]

posted by Ohlbe – France, 2020-12-10 18:43 (85 d 11:22 ago) – Posting: # 22125
Views: 1,815

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,370 posts in 4,463 threads, 1,495 registered users;
online 3 (0 registered, 3 guests [including 3 identified bots]).
Forum time: Saturday 06:06 CET (Europe/Vienna)

If debugging is the process of removing bugs,
then programming must be the process of putting them in.    Edsger W. Dijkstra

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