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).
You do not want your numbers changing in the next version of Excel.