Returns a bitwise 'AND' of two numbers.
Sintaxe
BITAND(number1, number2)Argumentos
number1obrigatório
The first integer to compare.
number2obrigatório
The second integer to compare.
The BITAND function compares the binary representation of two integers bit by bit. It returns a 1 for each bit position where both input numbers have a 1, and a 0 otherwise.
=BITAND(5, 3)→1Binary 101 (5) AND 011 (3) results in 001 (1).
Enter the function
Type =BITAND( into a cell.
Provide arguments
Input the two integers you wish to compare separated by a comma.
Close and calculate
Close the parenthesis and press Enter to see the result.
The BITAND function truncates non-integer values to integers before performing the calculation.