Purpose
Returns a 'Bitwise And' of two numbers
Return value
Decimal Number
Syntax
=BITAND(number1,number2)- number1 - A positive decimal number.
- number2 - A positive decimal number.
Using the BITAND function
The input numbers must be greater than or equal to zero and no larger than 2^48 - 1.
How It Works
The function performs a logical AND operation on each corresponding bit in the binary representation of the two numbers.
Related functions
AND Function
The Excel AND function is a logical function used to test multiple conditions at the same time. AND returns TRUE only if all the conditions are met. If any conditions are not met, the AND function returns FALSE. The AND function is commonly used with other...
BITOR Function
The Excel BITOR function returns a decimal number representing the bitwise OR of two numbers. For each corresponding bit in the binary representation of the numbers a logical OR operation is performed, and the resulting number returned.
