Description:
Perform the logical AND operation over members of a sequence.
Syntax:
A.cand()
Note:
The function performs a logical AND operation and returns a boolean value. It returns true when all members of sequence A are true; othewise it returns false. The data type of the operators in a logical operation needs to be boolean; will automatically convert to boolean type if an operator isn’t a boolean value.
Parameter:
|
A |
A table sequence |
Return value:
true/false
Example:
|
|
A |
|
|
1 |
=[2<10,3>4,1!=1] |
Return members true, false and false |
|
2 |
=A1.cand() |
false |
|
3 |
=[1==1,1<2].cand() |
true |
|
4 |
=[20,1<2].cand() |
True; automatically convert to the boolean data type |
|
5 |
=[null,1<2].cand() |
false |