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.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
8282874073235594120
true
Search Help Center
true
true
true
true
true
35
false
false