BITAND()

From Lianjapedia
Revision as of 08:43, 4 February 2013 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to perform bitwise AND operation

Syntax

BITAND(<expN1>,<expN2>[,…<expN26>])

See Also

BITCLEAR(), BITLSHIFT(), BITNOT(), BITOR(), BITRSHIFT(), BITSET(), BITTEST(), BITXOR()

Description

The BITAND() function performs a bitwise AND operation on the specified numeric parameters. Up to 26 parameters can be specified. These parameters, if not integers, will be converted to integer values before the operation takes place.

BITAND() compares each bit in turn of <expN1> and <expN2>. If both bits are 1, the corresponding bit in the result is set to 1, otherwise the result bit is 0. If <expN3> is specified, the initial result is compared bit by bit with <expN3> and a new result evaluated. This new result is then compared with <expN4>, if specified, and so on.

<expN1> bit <expN2> bit Result bit
0 0 0
0 1 0
1 1 1
1 0 0

Example

x = 3   && 0011
y = 6   && 0110
z = 7	&& 0111
? bitand(x,y)
         2     && 0010
? bitand(x,y,z)
         2     && 0010