Returns a bitwise 'AND' of two numbers.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
BITAND(number1, number2)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)Ergebnis: 1
Binary 101 (5) AND 011 (3) results in 001 (1).
The BITAND function truncates non-integer values to integers before performing the calculation.