Excel floating-point arithmetic - which type actually uses it

Question

From previous questions, someone pointed out that Excel uses double-precision 64-bit (8 bytes) floating.

Is it right - Are there any materials at all?

I'm trying to tie the numbers and it kills me!

Answer 1

According to this article, yes, it uses 64-bit double-precision floating-point numbers. The article also describes rounding errors, etc., associated with this format.

Answer 2

Take a look

Floating point arithmetic

In the Accuracy section

The floating point number is stored in binary in three parts in the 65-bit range: sign, exponent, and mantissa.

Here is another article

Understanding floating point accuracy, aka "Why does Excel give me obscure answers?"

Take a look at the Floating Point Structure section.