3 ms·
Was the maths ever wrong on the Excel spreadsheets? What was the cause when that happened?
by jmkni 7y ago
Was the maths ever wrong on the Excel spreadsheets? What was the cause when that happened?
- flybrand 7y agoYes - at that time there were two common errors that we would find about once per week that were known issues. (Can’t remember specifics - but we were thrilled when an old WSJ article noted them.) They were a combination of multiplication / exponential and some basic if-then statements. Easier items - where rounding resulted in paper errors were common.
- nwallin 7y agoThe fdiv bug in the Pentium x87 unit was discovered because someone was manually checking their Excel spreadsheets. https://en.wikipedia.org/wiki/Pentium_FDIV_bug https://en.wikipedia.org/wiki/Pentium_FDIV_bug
- jmkni 7y agoWaow, nuts/interesting. Thanks