Spread.Sheets Documentation
BITAND
Spread.Sheets Documentation > Formula Reference > Formula Functions > BITAND

This function calculates bitwise AND of the two specified values.

Syntax

BITAND(value1, value2)

Arguments

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

Remarks

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.

Data Types

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

Examples

BITAND(3,6) gives the result 2.

BITAND(4,5) gives the result 4.

See Also