# BITOR function

The BITOR function returns the bitwise Boolean OR of 2 numbers. The BITOR truth table is below:

 A B BITOR(A, B) 0 0 0 0 1 1 1 0 1 1 1 1

## Parts of a BITOR function

`BITOR(value1, value2)`

 Part Description Notes `value1` The first number. The given value must be a decimal representation of the number. `value2` The second number. The given value must be a decimal representation of the number.

## Sample formulas

`BITOR(9, 5)`

`BITOR(A1, 10)`

`BITOR(A1, B1)`

## Notes

It may make sense to use BITOR in conjunction with BIN2DEC as BITOR(BIN2DEC("1011"), BIN2DEC("1001")), which evaluates to "1011" in binary or 11 in decimal.

## Examples

In the following example, 9 in binary is “1001” and 5 in binary is 0101. The bitwise OR of 1001 and 0101 is 1101, which is 13 in decimal.

 A B 1 Formula Result 2 =BITOR(9, 5) 13

In this example, the bitwise OR of 1000 and 0001 is 1001, which is 9 in decimal:

 A B 1 Formula Result 2 =BITOR(BIN2DEC("1000"), BIN2DEC("0001")) 9

## Related functions

• BITAND: The BITAND function returns the bitwise boolean AND of two numbers. Learn more.
• BITXOR: The BITXOR function is a bitwise XOR (exclusive or) of 2 numbers that returns a bit of “1” if 2 bits are different, and a bit of “0” otherwise.
• BITLSHIFT: The BITLSHIFT function shifts the bits of the input a certain number of places to the left. Bits on the right are filled with zeroes (0s).
• BITRSHIFT: The BITRSHIFT function shifts the bits of the input a certain number of places to the right.
• BIN2DEC: The BIN2DEC function converts a signed binary number to decimal format.
• DEC2BIN: The DEC2BIN function converts a decimal number to signed binary format.