The BITAND function calculates a bitwise 'AND' of two numbers.
The function performs AND logic bit by bit on the numbers based on their binary representation. AND logic means that the value of each bit position is counted only if both parameter's bits at that position are 1.
Formula in cell B3:
Number 5 is 00000101 and 9 is 00001001. With AND logic bitwise the result is 00000001 which is number 1.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Engineering'
The BITAND function function is one of many functions in the 'Engineering' category.