3 ms·
Concur. A long time ago I spent a full day as a professional engineer trying to figure out why a microsoft Excel formula wasn't working. Turns out that the defa
by mojomark 6y ago
Concur. A long time ago I spent a full day as a professional engineer trying to figure out why a microsoft Excel formula wasn't working. Turns out that the default MS Excel order of operations was not PEMDAS, it's PE(M or D)(A or S), where 'X or X' is selected based on which operator comes next from left to right.(1) So frustrating. Always use parens.
1. https://edu.gcfglobal.org/en/excel2013/complex-formulas/1/ https://edu.gcfglobal.org/en/excel2013/complex-formulas/1/
- apricot 6y agoIsn't that the normal way to do things? Every teacher, every textbook has always told me that multiplication and division have the same priority, as do addition and subtraction.
- Dylan16807 6y agoWait, so what do you think 1+2-4+8 is supposed to be? It's not negative.