Documentation/Calc Functions/HEX2BIN

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

HEX2BIN

Category:

Add-in

Summary:

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

Syntax:

HEX2BIN(Number; Places)

Returns:

Arguments:

Number is a hexadecimal number or a string that represents a hexadecimal number. It can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.

Places is the number of places to be output.

Additional details:

Examples:

=HEX2BIN("6a";8) returns 01101010.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: