Learn Excel - Simplify Life with Excel Concepts

## Excel BIN2DEC Function

### How to use the BIN2DEC Function

This Excel tutorial explains how to use the Excel BIN2DEC function with syntax and examples.

### SUMMARY:

The Excel BIN2DEC function converts a binary number to a decimal number. The input number must contain only zeros and ones and be less than 10 characters long, otherwise the function returns the #NUM! error value.

For example,

• The formula =BIN2DEC(101) would return 5
• The formula =BIN2DEC(10) would return 2

### PURPOSE:

To converts a binary number to decimal.

### RETURN VALUE:

The BIN2DEC function returns a Decimal Number.

=BIN2DEC(number)

### ARGUMENTS:

The BIN2DEC function syntax has the following arguments:

• number: Required. The binary number you want to convert to a decimal.
• Number cannot contain more than 10 characters (10 bits).
• The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits.

### REMARKS:

• Negative numbers are represented using two's-complement notation.
• If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2DEC returns the #NUM! error value.