Spreadsheet Formulas - Syntax Operators
The mathematical operators that may be used in functions are as follows:
| Operator | Definition |
| +, -, *, /, ** | Arithmetic |
| ^ , ( ) | Exponentiation |
| <, >, >=, <=, <> | Relational |
| AND (equivalent to &) | Logical (see Examples) |
| OR (equivalent to |) | Logical (see Examples) |
| NOT (equivalent to ~) | Logical (see Examples) |
Note: A common error is caused by omitting parenthesis needed to adjust for the precedence of operators; for example, the expression x > 0 and x < 1 is incorrect and needs parentheses: (x > 0) and (x < 1) because relational operators (here, > and <) have a lower precedence than the conjunction (and).
This is the list of functions in the Operators group in the Function Browser:
| - | Subtraction. | |
| * | Multiplication. | |
| ** | Exponentiation (also ^). | |
| / | Division. | |
| ^ | Exponentiation (also **). | |
| + | Addition. | |
| < | Less than. | |
| <= | Less than or equal to. | |
| <> | Not equal to. | |
| > | Greater than. | |
| >= | Greater than or equal to. | |
| and | Logical conjunction. | |
| iif | iif(condition, expression1, expression2) | If "condition" is non-zero, then "expression1" is returned from the function, else "expression2" is returned. |
| LIKE | x LIKE y | Pattern matching operator. % matches any string of 0 or more characters. _ matches any single character. [] matches any single character in a range or set of characters (e.g. [a-f], [abcdef]). [^] matches any single character not in a range or set of characters (e.g. [^a-f], [^abcdef]) |
| MODULO | MODULO(number1, number2) | Divides the value of one expression by the value of another, and returns the remainder. |
| not | Logical negation. | . |
| or | Logical alternative |
See also: Spreadsheet Formulas - Overview, Spreadsheet Formulas - Syntax Summary, Spreadsheet Formulas - Examples.
For transformations of text variables (variables of type text), see also, Transformation of Text Variables (Variables of Type Text). Note that Statistica spreadsheets also support text labels for numeric values (these are labels attached to numeric values, which are used for display purposes only); when transforming the values with attached text labels, the respective transformations are performed on the numeric representations, and not on the text labels.