Excel BITAND function

Function              BITAND

Description        Excel BITAND function returns a decimal number representing the bitwise AND of two numbers.

Syntax                  BITAND (number1, number2)

number1             A positive decimal number.

number2             A positive decimal number.

Example:

Here how it works. Showing a bitwise AND result of two numbers.

Usage Notes:

The input numbers has to be greater than or equal to zero and less than or equal to 2^48 – 1