Excel BITAND Function

What is BITAND function in Excel?


The BITAND function is one of the Engineering functions of Excel.

It Returns a bitwise ‘And‘ of two numbers.

We can find this function in Engineering category of the insert function Tab.

How to use BITAND function in excel

  1. Click on an empty cell (like F5).
an empty cell in excel

2. Click on the fx icon (or press shift+F3).

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select Engineering category.

5. Select BITAND function.

6. Then select ok.

excel BITAND function

7. In the function arguments Tab you will see BITAND function.

8. Number1 is the decimal representation of the binary number you want to evaluate.

9. Number2 is the decimal representation of the binary number you want to evaluate.

10. You will see the results in the formula result section.

How to use BITAND function in excel

Examples of BITAND function in Excel

Example 1:

How to use BITAND function in excel

You can see examples of BITAND function below:

Examples of BITAND function in Excel
bitand(A2,B2) ----->>>>answer is  0

bitand(A3,B3) ----->>>>answer is  0

bitand(A4,B4) ----->>>>answer is  0

bitand(A5,B5) ----->>>>answer is  0

bitand(A6,B6) ----->>>>answer is  0

bitand(A7,B7) ----->>>>answer is  1

Purpose of BITAND function

It Returns a bitwise ‘And‘ of two numbers.

Return value of BITAND function

It returns a number.

Arguments of BITAND function

This function has just 2 Argument.

The argument of BITAND function is number.

Number1 is the decimal representation of the binary number you want to evaluate.

Number2 is the decimal representation of the binary number you want to evaluate.

The argument of BITAND function is required and not optional.

BITAND(number) = number

Version of excel supports BITAND function

This function is available for all excel versions (2003-2019)

Errors in BITAND function

BITAND related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *