Difference between revisions of "Logical Operators"
m (→Or) |
m |
||
Line 2: | Line 2: | ||
[[Category:Doc Status C]] <!-- For Lumina use, do not change --> | [[Category:Doc Status C]] <!-- For Lumina use, do not change --> | ||
− | + | 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: | When applied to values other than 0 or 1, other parameter values are interpreted as follows: | ||
Line 9: | Line 9: | ||
* '''Null''' results in a warning, with a Null result. | * '''Null''' results in a warning, with a Null result. | ||
* Any '''other''' data type results in an error. | * Any '''other''' data type results in an error. | ||
− | |||
− | |||
[[INF, NAN, Null, and Undefined]] | [[INF, NAN, Null, and Undefined]] |
Revision as of 04:30, 9 September 2015
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 or 1)
- Null results in a warning, with a Null result.
- Any other data type results in an error.
And
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 |
Or
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
Not | 0 | x | NaN | Null |
---|---|---|---|---|
1 | 0 | NaN | Null |
Comments
Enable comment auto-refresher