BITAND

Using the Excel BITAND Function

Summary

The Excel BITAND function returns a decimal number of the bitwise AND of two numbers.

Syntax

=BITAND (number1, number2)

Syntax Breakdown

Number 1
Required. Must be a decimal and >= to 0 (zero).

Number 2
Required. Must be a decimal and >= to 0 (zero).


Usage Notes

BITAND returns a decimal version of the bitwise AND of two numbers. The value of each bit position is counted only if both parameter's bits at that position are 1.

BITAND Errors
The function produces errors under the following scenarios:

1) The #VALUE! error if either argument is non-numeric

2) The #NUM! error if either argument is non-integer or is greater than (2^48) - 1

3) The #NUM! error if either argument is < 0 (zero)