Manuals/calci/BITAND
Jump to navigation
Jump to search
BITAND(n1)
- where specifies the numeric value on which the bitwise NOT operation is performed.
Description
- BITAND() returns the result of a bitwise NOT operation performed on a numeric value.
- specifies the numeric value. If is not an integer, it is converted to an integer before its bits are shifted.
- The numeric value returned by BITAND( ) represents with each bit of value 0 switched to 1 and each bit of value 1 switched to 0.
For Example,
BITAND(1) = -2 (Bit Not value of 'binary value 01' is '10' i.e -2.)
BITAND(False) = -1 (Bit Not value of 'binary value 00' is '11' i.e -1.)
Examples
- =BITAND(TRUE) = -2
- =BITAND(42) = -43
- =BITAND((2+7)>8) = -2
- =BITAND(0.5) = -1
- =BITAND("d")= -1
Related Videos
See Also
References