In This Topic

BITAND

In This Topic

This function calculates bitwise AND of the two specified values.

BITAND(*value1, value2*)

For the arguments of this function, both *values* must be in decimal form and greater than or equal to 0.

In this function, if the values of both parameter's bits at same position is 1 only then the value of each bit position is counted.

Accepts data in decimal form. Returns data in decimal form.

BITAND(3,6) gives the result 2.

BITAND(4,5) gives the result 4.

This function is available in Spread for Windows Forms 11.0 or later.