Excel BITOR Function

What is BITOR function in Excel?


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

It Returns a bitwise ‘or‘ of two numbers.

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

How to use BITOR 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).

fx icon in excel

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

insert function tab in excel

4. Select ENGINEERING category.

5. Select BITOR function.

6. Then select ok.

excel BITOR function

7. In the function arguments Tab you will see BITOR 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 BITOR function in excel

Examples of BITOR function in Excel

Example 1:

How to use BITOR function in excel

You can see examples of BITOR function below:

Examples of BITOR function in Excel
bitor(A2,B2) ----->>>>answer is  0

bitor(A3,B3) ----->>>>answer is  1

bitor(A4,B4) ----->>>>answer is  10

bitor(A5,B5) ----->>>>answer is  11

bitor(A6,B6) ----->>>>answer is  1111

bitor(A7,B7) ----->>>>answer is  1111

Purpose of BITOR function

It Returns a bitwise ‘or‘ of two numbers.

Return value of BITOR function

It returns a number.

Arguments of BITOR function

This function has just 2 Argument.

The argument of BITOR 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 BITOR function is required and not optional.

BITOR(number) = number

Version of excel supports BITOR function

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

Errors in BITOR function

BITOR related functions 

Leave a Reply

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