ID EN
#Engineering

BITAND

Excel Functions

Returns a 'Bitwise And' of two numbers

Syntax

EXCEL
=BITAND(number1, number2)

Arguments

Parameter Description
number1 A positive decimal number.
number2 A positive decimal number.

Return Value

Decimal Number

Details

The input numbers must be greater than or equal to zero and no larger than 2^48 - 1. The function performs a logical AND operation on each corresponding bit in the binary representation of the two numbers.

See Also

AND BITOR