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
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select ENGINEERING category.
5. Select BITOR function.
6. Then select ok.
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.
Examples of BITOR function in Excel
Example 1:
How to use BITOR function in excel
You can see examples of BITOR function below:
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 1111Purpose 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)
