BIN2DEC
Function converts Binary numbers to decimal. Excel 2013 and greater version supports Binary to Decimal Conversion by exposing BIN2DEC function. The parameter “number” should not be more than 10 bits (characters) else it throws #NUM! error.
Syntax
=BIN2DEC(number)
Parameter
- number: a mandatory parameter, refers to a binary number, should not be more than 10 characters (can be referred as bits)
Formula example

Output

Next >> Understand EOMONTH Function in Excel with example