이 함수는 Google Sheets에서도 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.