Engineering - BIN2DEC Function

Description

The BIN2DEC function converts a binary number to decimal.

BIN2DEC (number)

Argument	Description	Required/ Optional
number	The binary number you want to convert. 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. Negative numbers are represented using two's-complement notation.	Required

Argument

Description

Required/ Optional

number

The binary number you want to convert.

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.

Negative numbers are represented using two's-complement notation.

Required

If number is not a valid binary number, or if a number contains more than 10 characters (10 bits), BIN2DEC returns the #NUM! Error value.

Excel 2007, Excel 2010, Excel 2013, Excel 2016

advanced_excel_engineering_functions.htm