•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Arithmetic flaw in Excel's order of operations
My previous post had a bad title and got removed.
Excel reads "-2^2" as "(-2)^2" rather than "-(2^2)".
Some commenters stated that this correct, which it absolutely is not. One commenter kindly explained how fixing this flaw would have grave consequences for existing Excel sheets; the reason I post it here is that I do not wish the painful way I discovered it upon anyone 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
#natural language processing for spreadsheets
#generative AI for data analysis
#google sheets
#Excel
#arithmetic flaw
#order of operations
#-2^2
#(-2)^2
#-(2^2)
#existing Excel sheets
#commenters
#grave consequences
#commenter
#Excel sheets
#fixing this flaw
#painful way