Logical Operators
The logical operators, And, Or, and Not, are used to combine Boolean values. Analytica uses the values True = 1 and False = 0.
When applied to values other than 0 or 1, other parameter values are interpreted as follows:
- a non-zero numeric is treated as true
- NaN is treated as ambiguous (could be
0or1) - Null results in a warning, with a Null result.
- Any other data type results in an error.
A And B
True if both «A» and «B» are true. False if either «A» or «B» is false.
In this table, «x» signifies a numeric value that is not equal to zero (and is not NaN).
| And | 0 | x | NaN | Null |
|---|---|---|---|---|
| 0 | 0 | 0 | 0 | Null |
| x | 0 | 1 | NaN | Null |
| NaN | 0 | NaN | NaN | Null |
| Null | Null | Null | Null | Null |
A Or B
True if «A» or «B», or both, are true.
In this table, «x» signifies a numeric value that is not equal to zero (and is not NaN).
| Or | 0 | x | NaN | Null |
|---|---|---|---|---|
| 0 | 0 | 1 | NaN | Null |
| x | 1 | 1 | 1 | Null |
| NaN | NaN | 1 | NaN | Null |
| Null | Null | Null | Null | Null |
Not A
True if «A» is false.
| Not | 0 | x | NaN | Null |
|---|---|---|---|---|
| 1 | 0 | NaN | Null |
See Also
Comments
Enable comment auto-refresher