Arithmetic operators

You can combine numeric constants using the following arithmetic operators.

Operator

Meaning

+ (plus sign)

Addition

- (minus sign)

Subtraction

* (asterisk)

Multiplication

/ (forward slash)

Division

\ (back slash)

Same as / (forward slash), but returns zero when you divide by zero, rather than an undefined value.

^ (caret mark)

Exponentiation

TM1® evaluates arithmetic operators in the following order:

  1. Exponentiation
  2. Multiplication
  3. Division
  4. Addition
  5. Subtraction

You must use parentheses to force a different order of evaluation. The expression 2*3+4 produces the same result as (2*3)+4 because multiplication takes precedence over addition. To perform the addition first, rewrite the formula as 2*(3+4).

This changes the result from 10 to 14.