4 ms·
> What? Excel handles decimals just fine. I thought it uses binary floats just like any typical computer program? https://support.microsoft.com/en-us/help/7811
by throwaway613834 9y ago
> What? Excel handles decimals just fine.
I thought it uses binary floats just like any typical computer program? https://support.microsoft.com/en-us/help/78113/floating-point-arithmetic-may-give-inaccurate-results-in-excel https://support.microsoft.com/en-us/help/78113/floating-poin...
- dm319 9y agoYes, it doesn't use binary-encoded decimal. I guess the precision is good enough...
- throwaway613834 9y agoIf precision was sufficient then so many languages wouldn't put in support for decimal data types, right?
- dm319 9y agoDecimal precision isn't so important in modelling. More important in, say, accurate accounting of bitcoins.