"urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1737115705000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1737115705000","value":{"CustomField.default.label":"Value of {name}"},"lo...
The reason is: in the initial formula, Excel uses the binary approximation of 27625.1213, even though the constant appears to be 27625.1212999999. But when we edit the formula, Excel enters it exactly as it appears. So, the binary approximation of 27625.1212999999 is used. Thus, we might get ...
27625.1212+0.0001 onlyappearsto work because Excel formats only up to 15 significant digits, rounded. But with that expression in A2, note that ISNUMBER(MATCH(VALUE("27625.1213"), A2, 0)) returns FALSE. That is because the binary value of 27625.1212+0.0001 isnot the sameas t...
27625.1212+0.0001 onlyappearsto work because Excel formats only up to 15 significant digits, rounded. But with that expression in A2, note that ISNUMBER(MATCH(VALUE("27625.1213"), A2, 0)) returns FALSE. That is because the binary value of 27625.1212+0.0001 isnot the sameas t...
Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more > Share Resources
Excel Your community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visitMicrosoft Support Community. Forum Discussion