And a band saw will happily cut off your hand if you push it into the moving blade. That's why the best practices of operating one suggest that you never keep your hands anywhere near the cutting edge.
Excel's idiosyncrasies are very much on the level of the typical productive computing tool. They are less maddening than half the featureset of C++, three quarters of the featureset of Javascript, and 110% of the featureset of bash.
Despite that, people manage to get work done using bandsaws, C++, Javascript, and the occasional shell script.
Band saws, C++, Javascript have a different user group than Excel. Most of them have been trained on the tool they use.
If Excel were a band saw, there would be a lot more people missing fingers.
Excel's idiosyncrasies are very much on the level of the typical productive computing tool. They are less maddening than half the featureset of C++, three quarters of the featureset of Javascript, and 110% of the featureset of bash.
Despite that, people manage to get work done using bandsaws, C++, Javascript, and the occasional shell script.