BITAND

Returns the bitwise 'AND' of the specified numbers.

Syntax

BITAND( Integer x, Integer y ) → Integer

Parameters

x

Required. The first argument of the operation. Must be greater than or equal to zero.

y

Required. The second argument of the operation. Must be greater than or equal to zero.

Remarks

This function calculates the bitwise 'AND' of its arguments, that is, the value of each bit position is 1 only if both parameter's bits at that position are 1.

If either argument is less than 0 or greater than or equal to (2^48), BITAND returns the #NUM! error value. If an argument is not an integer number, the argument is converted automatically.

Example

Formula

=BITAND(5,4)
=BITAND(100,11)

See Also

Function Reference
BITOR Function
BITXOR Function
AND Function