Arithmetic operations

The following arithmetic operators are available:

+. Addition

. Subtraction

*. Multiplication

/. Division

**. Exponentiation

  • No two operators can appear consecutively.
  • Arithmetic operators cannot be implied. For example, (VAR1)(VAR2) is not a legal specification; you must specify VAR1*VAR2.
  • Arithmetic operators and parentheses serve as delimiters. To improve readability, blanks (not commas) can be inserted before and after an operator.
  • To form complex expressions, you can use variables, constants, and functions with arithmetic operators.
  • The order of execution is as follows: functions; exponentiation; multiplication, division, and unary –; and addition and subtraction.
  • Operators at the same level are executed from left to right.
  • To override the order of operation, use parentheses. Execution begins with the innermost set of parentheses and progresses out.