BITAND Function in Google Sheets

Perform a bitwise AND operation on two numbers using the BITAND function.

BITAND Function

The BITAND function in Google Sheets performs a bitwise AND operation on two numeric values.

Syntax

BITAND(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 AND operation on 12 and 5:

=BITAND(12, 5)

This will output 4.

  1. Using BITAND with Larger Values

Perform a bitwise AND operation on 25 and 19:

=BITAND(25, 19)

This will output 17.

Notes

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