Binary to Decimal Conversion Excel with step by step example

Binary to Decimal Conversion Excel with step by step example

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

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

Leave a Reply

Your email address will not be published. Required fields are marked *