SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / BITAND
In This Topic
    BITAND
    In This Topic

    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