•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel returns a non-zero result for a calculation that should be zero
=8400*(0.9-0.6-0.3)
Mathematically, this should evaluate to 0.
However, Excel returns:
0.0000000000000466
This seems inconsistent with expected arithmetic behavior.
Is this just floating point precision, or something else?
[link] [comments]
Want to read more?
Check out the full article on the original site