Google Sheets

BITOR: Google Sheets Formulae Explained

How do you use BITOR in Google Sheets?

BITOR is a logical operator in Google Sheets that allows you to test whether two expressions are both true or both false. The operator is written as "&&" in Google Sheets. For example, the following expression evaluates to true:


This expression evaluates to false:


What is the syntax of BITOR in Google Sheets?

BITOR is a Boolean operator that returns a logical "true" if either of its arguments is true. It is written as BITOR(x, y). For example, BITOR(1, 2) returns "true" because either 1 or 2 is true.

What is an example of how to use BITOR in Google Sheets?

BITOR (bitwise OR) is a Google Sheets function that returns the bitwise OR of two numbers. The function takes two arguments: the first argument is the number to be ORed with the second argument, and the second argument is the number of bits to OR. For example, the function returns the bitwise OR of the numbers 5 and 7 when written as 5 | 7.

When should you not use BITOR in Google Sheets?

There are a few occasions when you should not use the BITOR function in Google Sheets. BITOR can only be used with two inputs, so it cannot be used to compare more than two values. Additionally, BITOR cannot be used with text values. If either of these conditions are not met, the BITOR function will return an error.

What are some similar formulae to BITOR in Google Sheets?

BITOR is a formula in Google Sheets that returns the bitwise OR of two numbers. Here are some similar formulae in Google Sheets:

BITXOR: Returns the bitwise XOR of two numbers.

BITAND: Returns the bitwise AND of two numbers.

BITNOT: Returns the bitwise NOT of a number.

BITLSHIFT: Returns the bitwise left shift of a number.

BITRSHIFT: Returns the bitwise right shift of a number.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.