BITAND function
BITAND(Number1,
Number2) BITAND(Number1;
Number2)
Number1
Number or { Number }
The first parameter.
Number2
Number or { Number }
The second parameter.
Returns
Number or { Number }
The result of the bitwise operation.
Performs a bitwise AND operation.
Examples
DEC2BIN(BITAND(BIN2DEC("00010011"), BIN2DEC("00011000")),
8)DEC2BIN(BITAND(BIN2DEC("00010011");
BIN2DEC("00011000")); 8)
Returns "00010000".
BITAND(19,
24)BITAND(19; 24)
Returns 16. This example is equivalent to the preceding example, but does not convert the decimal numbers to binary to ease readability.