Re:Why does 0.1 and 0.2 = 0.30000000000000004?
by jdmichal on Thursday February 09, 2023 @12:24PM
(#34727519)
Ah, sorry for that I must have seen the updated one.
I agree with you that switching programs that are all using the IEEE floating-point formats with the same underlying hardware implementations should result in the same answers.
Anyway, yes, that's all true. Excel, Sheets, JavaScript numbers, Java doubles, Python floats, and so on all work this way. That's why I asked how switching spreadsheet implementations solved the problem.