Google Sheets-functie

HEX2BIN

Converts a hexadecimal number to a binary number.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

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.

Argumenten

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

Voorbeelden

=HEX2BIN("A")

Resultaat: 1010

Converts the hexadecimal value A to binary.

=HEX2BIN("F", 8)

Resultaat: 00001111

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

Veelgestelde vragen

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.

Gerelateerde functies

BIN2HEX DEC2HEX HEX2DEC