What is the syntax for BITAND in Excel?

The syntax for BITAND is: =BITAND(number1, number2)

What are common errors with BITAND?

#NUM! if numbers negative or > 2^48-1

How do I use the BITAND function?

To use BITAND, type =BITAND( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

Why is BITAND not working in my Excel?

Common issues with BITAND include #NUM! if numbers negative or > 2^48-1. Start by checking the syntax =BITAND(number1, number2), then verify each referenced cell or range.

Engineering

BITAND Function in Excel

Returns a bitwise AND of two numbers.

Syntax

=BITAND(number1, number2)

Arguments

number1 (required): First number
number2 (required): Second number

Examples

=BITAND(5, 3) - Bitwise AND of 5 and 3 - Result: 1

BITAND in technical sheets

Document units in adjacent cells — many engineering functions require exact unit strings.
Use [CONVERT](/functions/convert/) for unit changes before specialized formulas.
Validate inputs with [ISNUMBER](/functions/isnumber/) and range checks.

Common errors

#NUM! if numbers negative or > 2^48-1

Use cases

Bit manipulation
Programming
Data processing

Frequently asked questions

What is the BITAND function in Excel? BITAND returns a bitwise AND of two numbers. The syntax is =BITAND(number1, number2). Typical use cases include bit manipulation, programming, data processing.
How do I use the BITAND function? To use BITAND, type =BITAND( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
Why is BITAND not working in my Excel? Common issues with BITAND include #NUM! if numbers negative or > 2^48-1. Start by checking the syntax =BITAND(number1, number2), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.