Logical Operators

(Redirected from And)



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.

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


You are not allowed to post comments.