BITAND Function Explained

The BITAND function in Microsoft Excel returns a bitwise AND of two numbers. It takes two arguments, a number1 and a number2, and returns a number that has 1s in each bit position for which the corresponding bits of both number1 and number2 are 1s.

BITAND Function Syntax

BITAND(number1, number2)

  • number1: The first number to be used in the bitwise AND operation.
  • number2: The second number to be used in the bitwise AND operation.