Syntax

BITAND(</wiki/spaces/DASSB60/pages/5170465661>;</wiki/spaces/DASSB60/pages/5170465661>; ...)

Description

Bitwise AND operation on given integer arguments. The function converts the integers to binary and returns 1 in each bit position where all input arguments have a one in the corresponding position and zero in all others.

This function supports more than 255 arguments.

Examples

Column1	Column2	Column3	BITAND() returns
Example 1
2	3	6	2
(0010)	(0011)	(0110)	= 0010
Example 2
4	8	12	0
(0100)	(1000)	(1100)	= 0000
Example 3
23	8	109	5
(0010111)	(0111101)	(1101101)	= 0000101

Browser not supported