Re:Why does 0.1 and 0.2 = 0.30000000000000004?
by roxgib on Wednesday February 08, 2023 @03:55PM
(#34714961)
Even if you set the data format to 'currency' it still returns false (in Google Sheets). I realise they probably want consistency but it's weird they don't have an option to use a decimal type.
[ Parent
| on HN ]
Re:Why does 0.1 and 0.2 = 0.30000000000000004?
by codetrotter on Wednesday February 08, 2023 @04:12PM
(#34715252)
It is my impression of most spreadsheet software that the “data format” is more about display, and not about actually strongly typed representations of the data.