Spread.NET 17 Formula Reference
Formula Functions / Functions A to C / BITAND
In This Topic
    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.

    Data Types

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


    BITAND(3,6) gives the result 2.

    BITAND(4,5) gives the result 4.

    Version Available

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