## How to use the BITAND function

*Article updated on March 28, 2018*

The BITAND function calculates a bitwise 'AND' of two numbers.

The function performs AND logic bit by bit on the numbers based on their binary representation. AND logic means that the value of each bit position is counted only if both parameter's bits at that position are 1.

Formula in cell B3:

=BITAND(B3, B4)

Number 5 is 00000101 and 9 is 00001001. With AND logic bitwise the result is 00000001 which is number 1.

### Excel Function Syntax

BITAND(*number1*, *number2*)

### Arguments

number1 |
Required. The first number. |

number2 |
Required. The second number. |

### Comments

Maximum argument number is 2^48 = 2.81475E+14.

### Functions in 'Engineering'

The BITAND function function is one of many functions in the 'Engineering' category.

The BIN2DEC function converts a binary number to decimal. Formula in cell B3: =BIN2DEC(11001) Excel Function Syntax BIN2DEC(number) Arguments number […]

The BIN2HEX function converts a binary number to hexadecimal. Formula in cell B3: =BIN2HEX(11001) Excel Function Syntax BIN2HEX(number,[places]) Arguments number […]

The BIN2OCT function converts a binary number to octal. Formula in cell B3: =BIN2OCT(11001) Excel Function Syntax BIN2OCT(number,[places]) Arguments number […]

The BITAND function calculates a bitwise 'AND' of two numbers. The function performs AND logic bit by bit on the numbers […]

The BITLSHIFT function calculates a number whose binary representation is shifted left by a specified number of bits. Formula in […]

The BITOR function performs a bitwise 'OR' of two numbers. Bitwise meaning each digit in the binary equivalent. Formula in […]

The BITRSHIFT function calculates the number where the binary equivalent is shifted right by a specified number of bits and […]

The BITXOR function calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. XOR […]

The COMPLEX function returns a complex number based on a real and imaginary number. Formula in cell B3: =COMPLEX(2,3) Excel […]

The CONVERT function converts a number from one measurement system to another. Formula in cell E3: =CONVERT(B3, C3, D3) The […]

The DEC2BIN function converts a decimal number to a binary number. Formula in cell D3: =DEC2BIN(B3,C3) Excel Function Syntax DEC2BIN(number, […]

The DEC2HEX function converts a decimal number to a hexadecimal number. Formula in cell D3: =DEC2HEX(B3,C3) Excel Function Syntax DEC2HEX(number, […]

The DEC2OCT function converts a decimal number to an octal number. Formula in cell D3: =DEC2OCT(B3,C3) Excel Function Syntax DEC2OCT(number, […]