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):

BIN2DEC(number)

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:

BIN2DEC Function in Excel 1

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

Result:

BIN2DEC Function in Excel 2

Note:

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

previous BIN2DEC Function in Excel                                                                                                                next BIN2DEC Function in Excel