Natural Precedence

If a standard formula has two or more operators, the system performs the operations in the order of the operators' natural precedence.

The order of natural precedence to perform operations in an expression that has multiple operators is:

  1. Unary minus (-# where # is any number)

    Note:

    Do not add a space after the unary minus operator.

  2. Multiplication (*) and division (/)

  3. Subtraction (- #) and addition (+ # where # is any number)

    Note:

    Add a space after the subtraction and addition operator.

For example, if row 10 has a value of 8, the following expression produces a value of 20 for that column by calculating 3 * 4 + 8 = 20, following the order of natural precedence:

  [10] + 3 * 4