BIN2DEC Function in Excel – Convert Binary to Decimal in Excel

BIN2DEC Function in Excel converts Binary number to a decimal number.

Syntax of BIN2DEC Function in Excel (BINARY TO DECIMAL FUNCTION IN EXCEL):

Where the number argument is the binary number that is to be converted to a decimal.

 

Example of BIN2DEC Function in Excel (BINARY TO DECIMAL FUNCTION IN EXCEL):

Formula:

• The supplied binary value should not have more than 10 character

Result:

Note:

#NUM! – Error occurs if the supplied number argument is not recognized as a binary number, or contains more than 10 characters.