Exceljet

Quick, clean, and to the point

Order of operations

Excel's Order of operations

When evaluating a formula, Excel follows a standard math protocol called "order of operations". First any expressions in parentheses are evaluated. Next Excel will solve for any exponents. After exponents, Excel will perform multiplication and division, then addition and subtraction. If the formula involves concatenation, this will happen after standard math operations. Finally, Excel will evaluate logical operators, if present.

  1. Parentheses
  2. Exponents
  3. Multiplication and Division
  4. Addition and Subtraction
  5. Concatenation
  6. Logical operators