BITAND |
BITAND(number1, number2) |
Returns the bitwise AND of two numbers. |
number1 | The first number. |
number2 | The 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 |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top