BITAND
Returns a 'Bitwise And' of two numbers.
EngineeringEngineering & Science
What it does
Performs a bitwise AND operation on two integers. The result has bits set to 1 only if both input numbers have that bit set to 1.
Syntax
BITAND(number1, number2)
Arguments
number1(number) — First integer.number2(number) — Second integer.
Examples
Bitwise AND
Compare 13 (1101) and 25 (11001).
FORMULA
=BITAND(13, 25)
RESULT
9
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Val1 | Val2 |
| 2 | 13 | 25 |