Manuals/calci/BITAND

BITAND(n1,n2)

where $n1$ and $n2$ specifies the numeric value on which the bitwise NOT operation is performed.

Description

BITAND() returns the result of a bitwise AND operation performed on a numeric values.
and must be in decimal form and greater or equal to '0'.
The value of each bit position is counted only if both parameter's bits at that position are 1.
If either argument is less than 0, BITAND returns the #NUM! error value.
If either argument is a non-integer or is greater than (2^48)-1, BITAND returns the #NUM! error value.
If either argument is a non-numeric value, BITAND returns the #VALUE! error value.

For Example,

BITAND(1,6) = 0

BITAND(False) = -1 (Bit Not value of 'binary value 00' is '11' i.e -1.)