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.
How to use
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 require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use =AND(A1>0,A1<10). The AND function can be used as the logical test inside the IF...
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.
