Converts a binary number to a decimal number.
구문
BIN2DEC(number)인수
number필수
The binary number you want to convert, provided as a text string or a 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")→11Converts the binary value 1011 to the decimal value 11.
=BIN2DEC("1111111111")→-1Converts the 10-bit binary value representing -1 to its decimal equivalent.
Select a cell
Click on the cell where you want to display the decimal result.
Enter the formula
Type =BIN2DEC( followed by the binary number in quotes and a closing parenthesis.
Press Enter
Press the Enter key to calculate the decimal value.
It can handle up to 10 bits, ranging from 1111111111 (-1) to 0111111111 (511).