Difference between revisions of "Logical Operators"
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[category:Operators]] | [[category:Operators]] | ||
[[Category:Doc Status C]] <!-- For Lumina use, do not change --> | [[Category:Doc Status C]] <!-- For Lumina use, do not change --> | ||
| + | |||
| + | |||
| + | __TOC__ | ||
| + | |||
The logical operators, '''And''', '''Or''', and '''Not''', are used to combine Boolean values. Analytica uses the values <code>True = 1</code> and <code>False = 0</code>. | The logical operators, '''And''', '''Or''', and '''Not''', are used to combine Boolean values. Analytica uses the values <code>True = 1</code> and <code>False = 0</code>. | ||
| Line 15: | Line 19: | ||
In this table, «x» signifies a numeric value that is not equal to zero (and is not [[NaN]]). | In this table, «x» signifies a numeric value that is not equal to zero (and is not [[NaN]]). | ||
| − | {| class="wikitable" | + | |
| + | :{| class="wikitable" | ||
! And !! 0 !! x !! NaN !! Null | ! And !! 0 !! x !! NaN !! Null | ||
|- | |- | ||
| Line 37: | Line 42: | ||
In this table, «x» signifies a numeric value that is not equal to zero (and is not [[NaN]]). | In this table, «x» signifies a numeric value that is not equal to zero (and is not [[NaN]]). | ||
| − | {| class="wikitable" | + | |
| + | :{| class="wikitable" | ||
! Or !! 0 !! x !! NaN !! Null | ! Or !! 0 !! x !! NaN !! Null | ||
|- | |- | ||
| Line 56: | Line 62: | ||
True if «A» is false. | True if «A» is false. | ||
| − | {| class="wikitable" | + | :{| class="wikitable" |
! Not !! 0 !! x !! NaN !! Null | ! Not !! 0 !! x !! NaN !! Null | ||
|- | |- | ||
| Line 64: | Line 70: | ||
==See Also== | ==See Also== | ||
* [[INF, NAN, Null, and Undefined]] | * [[INF, NAN, Null, and Undefined]] | ||
| + | * [[Comparison Operators]] | ||
| + | * [[Expression_Syntax#Operator_Precedence|Operator precedence]] | ||
| + | * [[Operators]] | ||
| + | * [[Boolean or truth values]] | ||
Latest revision as of 20:51, 20 April 2016
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