The BITAND function returns the bitwise boolean AND of two numbers. Learn more.
The truth table of BITAND is provided below:
| A | B | BITAND(A,B) |
|---|---|---|
|
0
|
0 | 0 |
|
0
|
1 | 0 |
|
1
|
0 | 0 |
|
1
|
1 | 1 |
Parts of a BITAND function
BITAND(value1,value2)
| Part | Description | Notes |
value1
|
The first number. | Must be the decimal representation of the number. |
value2
|
The second number. | Must be the decimal representation of the number. |
Notes
It may make sense to use BITAND in conjunction with BIN2DEC as follows:
- BITAND(BIN2DEC(“1010”), BIN2DEC(“1001”)) which evaluates to “1000” in binary or 8 in decimal.
Examples
10 in decimal is “1010” in binary. 9 in decimal is “1001” in binary. The result is “1000” in binary, which is 8 in decimal.
| A | B | |
|---|---|---|
|
1
|
Formula | Result |
|
2
|
=BITAND(10,9)
|
8 |
The bitwise boolean AND of binary numbers “1110” and “0100” is the binary number “0100”, which is 4 in decimal.
| A | B | |
|---|---|---|
|
1
|
Formula | Result |
|
2
|
=BITAND(BIN2DEC("1110"), BIN2DEC("0100"))
|
4 |
Related functions
- BITOR: The BITOR function returns the bitwise boolean OR of two numbers.
- BITXOR: The BITXOR function returns the bitwise boolean XOR (exclusive OR) of two numbers.
- BITLSHIFT: The BITLSHIFT function shifts the bits of the input a certain number of places to the left. Bits on the right are filled with zeroes (0s).
- BITRSHIFT: The BITRSHIFT function shifts the bits of the input a certain number of places to the right. Bits on the right are filled with zeroes (0s).
- BIN2DEC : The BIN2DEC function converts a signed binary number to decimal format.
- DEC2BIN : The DEC2BIN function converts a decimal number to signed binary format.
