Documentation/Calc Functions/BIN2HEX

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

BIN2HEX

Category:

Add-in

Summary:

The result is the hexadecimal number for the binary number entered.

Syntax:

BIN2HEX(Number; Places)

Returns:

Arguments:

Number is a binary number. The number can have a maximum of 10 places (bits). The most significant bit is the sign bit. Negative numbers are entered as two's complement.

Places means the number of places to be output.

Additional details:

Examples:

=BIN2HEX(1100100;6) returns 000064.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: