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.

How to use 

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.