이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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.
=HEX2BIN("A")결과: 1010
Converts the hexadecimal value A to binary.
=HEX2BIN("F", 8)결과: 00001111
Converts F to binary and pads the result to 8 characters.
The number cannot contain more than 10 characters, and the most significant bit is the sign bit.