Difference between revisions of "Manuals/calci/BITAND"

Revision as of 04:14, 4 May 2017

BITAND(n1,n2)

where $n1$ and $n2$ specifies the numeric value on which the bitwise NOT operation is performed.

BITAND() returns the result of a bitwise AND operation performed on a numeric values.
$n1$ and $n2$ must be in decimal form and greater or equal to '0'.
The value of each bit position is counted only if both parameter's bits at that position are 1.
If either argument is less than 0, BITAND returns the #NUM! error value.
If either argument is a non-integer or is greater than (2^48)-1, BITAND returns the #NUM! error value.
If either argument is a non-numeric value, BITAND returns the #VALUE! error value.

For Example,

BITAND(1,6) = 0

BITAND(False) = -1 (Bit Not value of 'binary value 00' is '11' i.e -1.)

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''BITAND(n1)'''</div><br/>
+<div style="font-size:30px">'''BITAND(n1,n2)'''</div><br/>
-*where <math>n1</math> specifies the numeric value on which the bitwise NOT operation is performed.
+*where <math>n1</math> and <math>n2</math> specifies the numeric value on which the bitwise NOT operation is performed.
 == Description ==
-*BITAND() returns the result of a bitwise NOT operation performed on a numeric value.
+*BITAND() returns the result of a bitwise AND operation performed on a numeric values.
-*<math>n1</math> specifies the numeric value.  If <math>n1</math> is not an integer, it is converted to an integer before its bits are shifted.
+*<math>n1</math> and <math>n2</math> must be in decimal form and greater or equal to '0'.
-*The numeric value returned by BITAND( ) represents <math>n1</math> with each bit of value 0 switched to 1 and each bit of value 1 switched to 0.
+*The value of each bit position is counted only if both parameter's bits at that position are 1.
+*If either argument is less than 0, BITAND returns the #NUM! error value.
+*If either argument is a non-integer or is greater than (2^48)-1, BITAND returns the #NUM! error value.
+*If either argument is a non-numeric value, BITAND returns the #VALUE! error value.
 For Example,
-BITAND(1) = '''-2''' (Bit Not value of 'binary value 01' is '10' i.e -2.)
+BITAND(1,6) = 0
 BITAND(False) =  '''-1''' (Bit Not value of 'binary value 00' is '11' i.e -1.)