•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