BITAND function
Returns a 16-bit binary number in which each bit is set to 1 only if the corresponding bit in both binarynumber1 and binarynumber2 is 1. Otherwise, the bit is set to 0. This function can be used to test and change properties of a shape that are stored as bit masks, for example, the shape's text format.
Syntax
BITAND(binarynumber1,binarynumber2)
Example
BITAND(12,6)
Returns 4. The 12 = 0...01100. The 6 = 0...00110. Therefore, BITAND(12,6) = 0...00100.