Description:
Perform bitwise operation on integers.
Syntax:
and(xi,…)
and(A)
Note:
The function performs bitwise operation on integers. It supports the decimal data without the fractional part.
Parameter:
A |
A sequence. |
xi |
The numerical expression based on which you perform the bitwise AND operation. |
Return value:
Integer
Example:
|
A |
|
1 |
=and(6,11) |
2. |
2 |
=and([11,13,15]) |
9. |
3 |
=and(decimal(6),11) |
2, which is the decimal type. |
4 |
=and(decimal(6),decimal(11)) |
2, which is the decimal type. |