Hacker News new | ask | show | jobs
by ekjhgkejhgk 116 days ago
From your second link

> Therefore, the problem is not necessarily with Excel. Equally, the problem is not with the IEEE 754 standard either. It’s just the complex nature of the world of mathematics and computing that we live in.
2 comments
fweimer 116 days ago
The IEEE 754 standard covers decimal floating point arithmetic, too. Decimal floating point avoids issues like 0.1 + 0.1 + 0.1 not being equal to 0.3 despite usually being displayed as 0.3. Maybe it's reasonable to use that instead?

Some earlier spreadsheets such as Multiplan used it (but not in the IEEE variety) because it was all soft-float for most users anyway.

link
Betelbuddy 116 days ago
Excel the one who decided to use only 15 digits. It is an Excel problem...
link