Note: This is a work in progress and many formatting issues have been fixed. Read more about the project on the home page.
Comparison operators
=, is
Results in true if the expression to its left and the expression to its right have the same values. The expressions can be arithmetic, text, or logical.
<>, ≠, is not
Results in true if the expression to its left and the expression to its right have different values. The expressions can be arithmetic, text, or logical.
Note: To get the character ≠, hold down Option and press =.
<
Results in true if the expression to its left has a value less than the one to its right. The expressions can be both arithmetic or both text.
>
Results in true if the expression to its left has a value greater than the one to its right. The expressions can be both arithmetic or both text.
<=, ≤
Results in true if the expression to its left has a value less than or equal to the one to its right. The expressions can be both arithmetic or both text.
Note: To get the character ≤, hold down Option and press <.
>=, ≥
Results in true if the expression to its left has a value greater than or equal to the one to its right. The expressions can be both arithmetic or both text.
Note: To get the character ≥, hold down Option and press >.
Contains
Results in true if the text string yielded by the expression on its right is found in the text string yielded by the expression on its left (the converse of the operator is in).
is in
Results in true if the text string yielded by the expression on its left is found in the text string yielded by the expression on its right (the converse of the operator contains).
is not in
Results in true if the text string yielded by the expression on its left is not found in the text string yielded by the expression on its right (the opposite of the operator is in).
is within
Results in true if the point yielded by the expression on its left is contained within the rectangle yielded by the expression on its right.
is not within
Results in true if the point yielded by the expression on its left is not contained within the rectangle yielded by the expression on its right.
