News for hackers. Stuff that matters.
Re:Why does 0.1 and 0.2 = 0.30000000000000004? by jdsully on Wednesday February 08, 2023 @08:01PM (#34718246)
Because perf was super important for a spreadsheet in the 90s, and now back compatibility is super important.

You do not want your numbers changing in the next version of Excel.

Re:Why does 0.1 and 0.2 = 0.30000000000000004? by cm2187 on Thursday February 09, 2023 @02:39AM (#34720861)
I don't think he meant Excel. You can't use decimals in excel. First you will overflow immediatly (like multiply two numbers in trillons). Then your rounding will kill small amounts (like percentages). There is no alternative to floats in excel.
Re:Why does 0.1 and 0.2 = 0.30000000000000004? by jdsully on Thursday February 09, 2023 @04:18AM (#34721506)
The predecessor to excel (multi plan) used binary coded decimal.

But there’s nothing stopping you from doing arbitrary precision decimal in excel except back compatibility (and all the thousands of lines of code looking for a float).