Spreadsheet failures, any recent examples? [Software]

posted by Ohlbe – France, 2020-12-10 18:43 (655 d 20:30 ago) – Posting: # 22125
Views: 6,514

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,391 posts in 4,685 threads, 1,594 registered users;
online 5 (0 registered, 5 guests [including 3 identified bots]).
Forum time: Tuesday 16:13 CEST (Europe/Vienna)

Statistics. A sort of elementary form of mathematics which consists of
adding things together and occasionally squaring them.    Stephen Senn

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