PEMDAS is an acronym that represents the order of operations in mathematics, which also applies to Excel formulas. Understanding this sequence is important, as it specifies how mathematical ...

Nope, the blame in this case and in countless similar cases I’ve encountered over the years rested squarely with the fictitious Aunt Sally of “Please excuse my dear Aunt Sally” (or PEMDAS ...

Applying PEMDAS, the first step is to multiply and divide because there are no parenthesis or exponents. After solving 3 x 3 and 3 ÷ 3, the equation becomes 9 - 1 + 3.

Hint: You’ll need to revisit your grade school order of operations lesson – parentheses, exponents, multiplication, division, addition and subtraction (PEMDAS) ­– to solve each row.