/text/scalc/01/04060120.xhp Bit Operation Functions

BITAND function BITAND Returns a bitwise logical "and" of the parameters. Syntax BITAND(number1; number2) Number1 and number2 are positive integers less than 2 ^ 48 (281 474 976 710 656). Example =BITAND(6;10) returns 2 (0110 & 1010 = 0010).

BITOR function BITOR Returns a bitwise logical "or" of the parameters. Syntax BITOR(number1; number2) Number1 and number2 are positive integers less than 2 ^ 48 (281 474 976 710 656). =BITOR(6;10) returns 14 (0110 | 1010 = 1110).

BITXOR function BITXOR Returns a bitwise logical "exclusive or" of the parameters. Syntax BITXOR(number1; number2) Number1 and number2 are positive integers less than 2 ^ 48 (281 474 976 710 656). Example =BITXOR(6;10) returns 12 (0110 ^ 1010 = 1100)

BITLSHIFT function BITLSHIFT Shifts a number left by n bits. Syntax BITLSHIFT(number; shift) Number is a positive integer less than 2 ^ 48 (281 474 976 710 656). Shift is the number of positions the bits will be moved to the left. If shift is negative, it is synonymous with BITRSHIFT (number; -shift). Example =BITLSHIFT(6;1) returns 12 (0110 << 1 = 1100).

BITRSHIFT function BITRSHIFT Shifts a number right by n bits. Syntax BITRSHIFT(number; shift) Number is a positive integer less than 2 ^ 48 (281 474 976 710 656). Shift is the number of positions the bits will be moved to the right. If shift is negative, it is synonymous with BITLSHIFT (number; -shift). Example =BITRSHIFT(6;1) returns 3 (0110 >> 1 = 0011).