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.
Was this article helpful?
How can we improve it?