Google Sheets-funktion

HEX2BIN

Converts a hexadecimal number to a binary number.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

HEX2BIN(number, [places])

The HEX2BIN function converts a hexadecimal string into its binary equivalent. If the number is negative, the function returns a 10-character two's complement binary number.

Argument

numberobligatorisktThe hexadecimal number you want to convert, up to 10 characters long.
placesvalfrittThe number of characters to use for the output; useful for padding with leading zeros.

Exempel

=HEX2BIN("A")

Resultat: 1010

Converts the hexadecimal value A to binary.

=HEX2BIN("F", 8)

Resultat: 00001111

Converts F to binary and pads the result to 8 characters.

Vanliga frågor

What is the maximum value HEX2BIN can handle?

The number cannot contain more than 10 characters, and the most significant bit is the sign bit.

Relaterade funktioner

BIN2HEX DEC2HEX HEX2DEC