BITAND

BITAND(number1, number2)

Returns the bitwise AND of two numbers.

number1The first number.
number2The second number.

REMARKS
* 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
* You can use the BITOR function to return the bitwise OR of two numbers.
* You can use the BITXOR function to return the bitwise Exclusive OR of two numbers.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1??


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