Summary

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

Purpose
Returns a 'Bitwise And' of two numbers
Return value
Decimal Number
Syntax
=BITAND(number1, number2)
  • number1 - A positive decimal number.
  • number2 - A positive decimal number.

Using the BITAND function

The input numbers must be greater than or equal to zero and no larger than 2^48 - 1.

How It Works

The function performs a logical AND operation on each corresponding bit in the binary representation of the two numbers.

BITAND Internal Binary Representation

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Related functions

Excel AND Function

AND Function

The Excel AND function is a logical function used to test multiple conditions at the same time. AND returns TRUE only if all the conditions are met. If any conditions are not met, the AND function returns FALSE. The AND function is commonly used with other functions like IF, NOT, and OR to create …
Excel BITOR Function

BITOR Function

The Excel BITOR function returns a decimal number representing the bitwise OR of two numbers. For each corresponding bit in the binary representation of the numbers a logical OR operation is performed, and the resulting number returned.

Related functions

Links