Math Operators and the Order of Operations

Contact Us or call 1-877-932-8228
Math Operators and the Order of Operations

Math Operators and the Order of Operations

Math Operators

The six mathematical operators you need to know to enter basic formulas in Excel are:

  1. Addition. Plus sign (+).
  2. Subtraction. Minus sign (-).
  3. Multiplication. Asterisk (*).
  4. Division. Forward slash (/).
  5. Percent. Percent sign (%).
  6. Exponentiation. Exponents sign (^).

Math Operators

When a formula uses more than one operator, the order of operations in Excel is as follows:

  1. Parentheses. Operations contained in parentheses (or brackets) are executed first.
  2. Exponents. Exponents are executed second.
  3. Multiplication / Division. Multiplication and division, which Excel treats equally, are executed third, from left to right.
  4. Addition / Subtraction. Addition and subtraction, which Excel treats equally, are executed last, from left to right.
Next