BITOR Function in Google Sheets

Perform a bitwise OR operation on two numbers using the BITOR function.

BITOR Function

The BITOR function in Google Sheets performs a bitwise OR operation on two numeric values.

Syntax

BITOR(value1, value2)
  • value1: The first value in the operation. This is a required parameter.
  • value2: The second value in the operation. This is also a required parameter.

Examples

  1. Basic Example

Perform a bitwise OR operation on 12 and 5:

=BITOR(12, 5)

This will output 13.

  1. Using BITOR with Larger Values

Perform a bitwise OR operation on 25 and 19:

=BITOR(25, 19)

This will output 27.

Notes

  • The function returns a decimal number that represents the result of the bitwise OR operation on the binary representations of the input values.
  • BITAND: Perform a bitwise AND operation on two numbers.
  • BITXOR: Perform a bitwise XOR operation on two numbers.