4 ms·

That depends https://randomascii.wordpress.com/2012/03/08/float-precisionfrom-zero-to-100-digits-2/ https://randomascii.wordpress.com/2012/03/08/float-precision

• slver 5y ago
  A lot of these edge cases are about theoretical concerns like "how many digits we need in decimal to represent an exact IEEE binary float". In practice a double is 15.6 digits precise, which Excel rounds to 15 to eliminate some weirdness. In their documentation they do cite their number type as 15 digit precision type. Ergo that's the semantic they've settled on.