この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
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.
=BIN2HEX("11111011")結果: FB
Converts the binary value 11111011 to its hexadecimal equivalent FB.
=BIN2HEX("101", 4)結果: 0005
Converts 101 to hexadecimal and pads the result to 4 characters.
The function can handle binary numbers up to 10 bits (for positive numbers) or 10 characters (for negative numbers).