Returns a bitwise 'AND' of two numbers.
تعمل هذه الدالة في 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.