BITAND(number1, number2)

Returns the bitwise AND of two numbers.

number1The first number.
number2The second number.

Remarks

* Added in Excel 2013.
* This function returns a decimal.
* The value of each bit position is counted only if both parameters have a 1 at that position.
* If "number1" < 0, then #NUM is returned.
* If "number2" < 0, then #NUM is returned.
* If "number1" is not an integer, then #NUM is returned.
* If "number2" is not an integer, then #NUM is returned.
* If "number1" > (2^48)-1, then #NUM is returned.
* If "number2" > (2^48)-1, then #NUM is returned.
* If "number1" is not numeric, then #VALUE is returned
* If "number2" is not numeric, then #VALUE is returned
* For the Microsoft documentation refer to support.office.com

 A
1??


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top