3 ms·
>A famous one is that floating point math in excel can give you different answers for "is this the same as that" depending on how you write the equation, for ex
by _dain_ 3y ago
>A famous one is that floating point math in excel can give you different answers for "is this the same as that" depending on how you write the equation, for example.
Is this specific to Excel? Floating point math can do that regardless of the platform. Addition on floats isn't associative!
- mikehollinger 3y ago> Is this specific to Excel? No. And yet they still have situations where excel itself will differ from ieee 754. See https://learn.microsoft.com/en-us/office/troubleshoot/excel/floating-point-arithmetic-inaccurate-result https://learn.microsoft.com/en-us/office/troubleshoot/excel/...