この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
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)結果: 1
Binary 101 (5) AND 011 (3) results in 001 (1).
The BITAND function truncates non-integer values to integers before performing the calculation.