Google Sheets-functie

BIN2HEX

Converts a binary number to a hexadecimal number.

Formule genereren met AI Dezelfde functie in Excel

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

Syntaxis

BIN2HEX(number, [places])

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

Argumenten

numbervereistThe binary number you want to convert, provided as a string or number.
placesoptioneelThe number of characters to use in the output; useful for padding with leading zeros.

Voorbeelden

=BIN2HEX("11111011")

Resultaat: FB

Converts the binary value 11111011 to its hexadecimal equivalent FB.

=BIN2HEX("101", 4)

Resultaat: 0005

Converts 101 to hexadecimal and pads the result to 4 characters.

Veelgestelde vragen

What is the maximum binary number BIN2HEX can handle?

The function can handle binary numbers up to 10 bits (for positive numbers) or 10 characters (for negative numbers).

Gerelateerde functies

HEX2BIN DEC2BIN BIN2DEC