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 specifyVAR1*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.