이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
BIN2DEC(number)The BIN2DEC function takes a binary string and returns its equivalent decimal integer. The number argument must be a valid binary string with a maximum of 10 characters (10 bits), where the most significant bit is the sign bit.
=BIN2DEC("1011")결과: 11
Converts the binary value 1011 to the decimal value 11.
=BIN2DEC("1111111111")결과: -1
Converts the 10-bit binary value representing -1 to its decimal equivalent.
It can handle up to 10 bits, ranging from 1111111111 (-1) to 0111111111 (511).