# BITAND function

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.