Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Has MS ever fixed the bad arithmetic implementation Excel used, that produced explicitly wrong answers for ordinary computations? Maybe an optional setting for a worksheet "Produce right answers"? And, "New worksheets should have 'Produce right answers' set"?

(I don't recall the details about the bad arithmetic.)



Probably you should give an example. Afaik, there was never an issue about computational accuracy and you should be knowing that almost fortune 500 companies use it for their day to day sales/financial data


There are (were, cannot say if fixed and in which version) a couple ones that I remember.

One is not really an error, it is more like GIGO in the Average function:

https://exceloffthegrid.com/excels-average-function-the-hidd...

The other one is actually an error due to internal number storing (floating point):

https://docs.microsoft.com/en-us/office/troubleshoot/excel/f...

More generally there is 15 digit precision that can create issues, but the "real bug" was in Excel 2007

77.1 multiplied by 850 gave apparently 100,000 instead of 65,535

https://news.ycombinator.com/item?id=59392

https://www.journalofaccountancy.com/issues/2014/mar/excel-c...


None of that contradicts.




Consider applying for YC's Summer 2026 batch! Applications are open till May 4

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: