•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
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#row zero
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel
#calculation
#floating point precision
#arithmetic behavior
#mathematically
#non-zero result
#evaluate
#unexpected result
#expected behavior
#zero result
#calculation error
#numeric precision