Using Valid Operators for Expressions
The operators that can be used to define an expression or function have a sequence in which they are performed. The following list shows both the valid operators and the sequence in which they are accepted (listed in decreasing precedence):
|
( ) |
parenthesis |
1 |
|
! |
not |
2 |
|
^ (or **) |
exponentiation (If you use "**" for exponentiation, as in previous software versions, it is automatically changed to "^".) |
3 |
|
- |
unary minus |
4 |
|
* |
multiplication |
5 |
|
/ |
division |
5 |
|
+ |
addition |
6 |
|
- |
subtraction |
6 |
|
== |
equals |
7 |
|
!= |
not equals |
7 |
|
> |
greater than |
7 |
|
< |
less than |
7 |
|
>= |
greater than or equal to |
7 |
|
<= |
less than or equal to |
7 |
|
&& |
logic and |
8 |
|
|| |
logic or |
8 |