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