Check Sheet Logo
Check Sheet


The BITOR function returns a bitwise OR of two numbers.


Use the BITOR formula with the syntax shown below, it has 2 required parameters:

=BITOR(value1, value2)
  1. value1 (required):
    The first number or range to perform bitwise OR on.
  2. value2 (required):
    The second number or range to perform bitwise OR on.


Here are a few example use cases that explain how to use the BITOR formula in Google Sheets.

Combine binary values

Use BITOR to combine two binary values into a single value that has all the bits that are set in either value.

Set bit flags

Use BITOR to set one or more bit flags in a binary value by bitwise ORing the value with the flag(s).

Create a bitmask

Use BITOR to create a bitmask that can be used to test for multiple conditions at once by bitwise ORing the values of the conditions.

Common Mistakes

BITOR not working? Here are some common mistakes people make when using the BITOR Google Sheets Formula:

Using non-numeric inputs

Both inputs to BITOR must be numeric values. If you try to use non-numeric inputs, you will get a #VALUE! error.

Using cell ranges with different dimensions

If you try to use cell ranges with different dimensions as inputs to BITOR, you will get a #VALUE! error.

Not using enough arguments

You must provide two arguments to BITOR in order for it to work correctly. If you provide only one argument or more than two arguments, you will get a #VALUE! error.

The following functions are similar to BITOR or are often used with it in a formula:


    The BITAND function returns a bitwise AND of two numbers. This function is commonly used in engineering applications where binary digits are manipulated to perform logical operations. The function takes two inputs, value1 and value2, and returns a decimal number that represents the bitwise AND of the two inputs.


    The BITXOR function returns the bitwise XOR of two numbers. The function takes two numeric arguments and returns the result of the bitwise XOR operation performed on them.


    The DEC2BIN formula is used to convert a decimal number to a binary number. This is commonly used in engineering and computer science to represent numbers in their binary form. The formula takes in a decimal number and an optional number of significant digits to include in the binary representation.

Learn More

You can learn more about the BITOR Google Sheets function on Google Support.