Manuals/calci/BITAND

Revision as of 05:36, 4 May 2017 by Swapna (talk | contribs) (→‎Description)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
BITAND(n1,n2)


  • where and specify the numeric values on which the bitwise AND operation is performed.


Description

  • BITAND() returns the result of bitwise AND operation performed on numeric values.
  •   and   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 a non-numeric value, BITAND returns the #VALUE! error value.

For Example,

BITAND(1,6) = 0 (The binary representation of 1 is 1, and the binary representation of 6 is 110. Their bits do not match at any position. This is returned as 0.

BITAND(true, true) = 1 (Bit AND value of 'true' is '1'. Bits match the position, hence result is 1.)

Examples

  1. =BITAND(3,5) = 1
  2. =BITAND(17,-22) = 0
  3. =BITAND(-9,-3) = -11
  4. =BITAND(0.5,0.1) = 0


Related Videos

AND


See Also


References