Using the Excel BIN2DEC Function


The Excel BIN2DEC function converts a binary number to a decimal. Inputs must contain only 0 (zero) and 1, and must be less than 10 characters, otherwise the function will return the #NUM! error.


=BIN2DEC (number)

Syntax Breakdown

Required. The number, in binary format, that you wish to convert to a decimal. Negative numbers are represented using two's-complement notation. Number must be less than 10 characters (10 bits).

Usage Notes

BIN2DEC converts a number from binary to its decimal equivalent. The first bit indicates if the number is negative or positive. The remaining 9 digits represent the actual number.

BIN2DEC Errors
The function will return an error in the following instances:

1) The binary input is an invalid binary number

2) The number argument is greater than 10 characters (10 bits)

Excel BIN2DEC Error