You may not have heard about the so-called “floating point error” in Excel, in which seemingly simple calculations can give an apparently wrong result. It can certainly be bewildering if you experience it for the first time. To be clear this is not an issue with Excel but a function of how some numbers are represented in binary format(1). For very long numbers, more than 15 digits, one common solution is to represent them as text, but what happens when the text solution also produces a floating point error?
