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 that the system follows for performing operations in an expression that has multiple operators is as follows:

  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, suppose a standard row formula uses this expression:

  [10] + 3 * 4

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