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
0
or1
) - 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