BITAND
- Juliane Wetzel
Owned by Juliane Wetzel
Apr 29, 2020
Loading data...
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 |