Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Bit Operation Functions

To access this command...

Insert - Function - Category Mathematical

BITAND

Returns a bitwise logical "and" of the parameters.

This function is available since Office 3.5.

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

BITLSHIFT

Shifts a number left by n bits.

This function is available since Office 3.5.

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

BITOR

Returns a bitwise logical "or" of the parameters.

This function is available since Office 3.5.

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

BITRSHIFT

Shifts a number right by n bits.

This function is available since Office 3.5.

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

BITXOR

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

This function is available since Office 3.5.

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)