The Excel Bitwise functions convert the supplied integer value(s) to binary form and then perform an operation on the individual bits.
The result is then converted back to an integer value before being returned.
Further information on Bitwise operations is provided on the Wikipedia Bitwise Operation Page
The Excel BitAnd function returns the bitwise 'AND' for two supplied integers.
Note: the BitAnd function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.
The syntax of the function is:
where the supplied number arguments are positive integers.
Formula:

Result:

DecimalBinary Conversion
If you want to work through the stages of a bitwise 'AND' operation you can use the Excel DEC2BIN and BIN2DEC functions to convert between decimal and binary forms.In the above example:
Formula:

Result:

In the above example:
Further information and examples of the Excel BitAnd function are provided on the Microsoft Office website.
#NUM!   
Occurs if either:

#VALUE!    Occurs if one or both of the supplied number arguments is nonnumeric. 