Bit Operation Functions

แƒ‘แƒ แƒซแƒแƒœแƒ”แƒ‘แƒแƒ–แƒ” แƒฌแƒ•แƒ“แƒแƒ›แƒ˜แƒกแƒแƒ—แƒ•แƒ˜แƒก...

แƒฉแƒแƒกแƒ›แƒ - แƒคแƒฃแƒœแƒฅแƒชแƒ˜แƒ - แƒ™แƒแƒขแƒ”แƒ’แƒแƒ แƒ˜แƒ แƒ›แƒแƒ—แƒ”แƒ›แƒแƒขแƒ˜แƒ™แƒฃแƒ แƒ˜


แƒ‘แƒ˜แƒขแƒฃแƒ แƒ˜แƒแƒœ

Returns a bitwise logical "or" of the parameters.

tip

This function is available since LibreOffice 3.5.


แƒกแƒ˜แƒœแƒขแƒแƒฅแƒกแƒ˜

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).

แƒ‘แƒ˜แƒขแƒฃแƒ แƒ˜แƒแƒ แƒแƒแƒœ

Returns a bitwise logical "exclusive or" of the parameters.

tip

This function is available since LibreOffice 3.5.


แƒกแƒ˜แƒœแƒขแƒแƒฅแƒกแƒ˜

BITXOR(number1; number2)

Number1 and number2 are positive integers less than 2 ^ 48 (281 474 976 710 656).

แƒ›แƒแƒ’แƒแƒšแƒ˜แƒ—แƒ˜

=BITXOR(6;10) returns 12 (0110 ^ 1010 = 1100)

แƒ‘แƒ˜แƒขแƒฃแƒ แƒ˜แƒ“แƒ

Returns a bitwise logical "and" of the parameters.

tip

This function is available since LibreOffice 3.5.


แƒกแƒ˜แƒœแƒขแƒแƒฅแƒกแƒ˜

BITAND(number1; number2)

Number1 and number2 are positive integers less than 2 ^ 48 (281 474 976 710 656).

แƒ›แƒแƒ’แƒแƒšแƒ˜แƒ—แƒ˜

=BITAND(6;10) returns 2 (0110 & 1010 = 0010).

แƒ‘แƒ˜แƒขแƒฃแƒ แƒ˜แƒ›แƒแƒ แƒชแƒฎแƒฌแƒแƒœ

Shifts a number left by n bits.

tip

This function is available since LibreOffice 3.5.


แƒกแƒ˜แƒœแƒขแƒแƒฅแƒกแƒ˜

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).

แƒ›แƒแƒ’แƒแƒšแƒ˜แƒ—แƒ˜

=BITLSHIFT(6;1) returns 12 (0110 << 1 = 1100).

แƒ‘แƒ˜แƒขแƒฃแƒ แƒ˜แƒ›แƒแƒ แƒฏแƒ•แƒฌแƒแƒœ

Shifts a number right by n bits.

tip

This function is available since LibreOffice 3.5.


แƒกแƒ˜แƒœแƒขแƒแƒฅแƒกแƒ˜

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).

แƒ›แƒแƒ’แƒแƒšแƒ˜แƒ—แƒ˜

=BITRSHIFT(6;1) returns 3 (0110 >> 1 = 0011).

Please support us!