How to use BIN2DEC Function in Excel

The Excel BIN2DEC function converts a binary number to the decimal equivalent. The input number must contain only zeros and ones and be less than 10 characters long, otherwise the function returns the #NUM! error value.

Syntax: =BIN2DEC (number)

The BIN2DEC function syntax has the following arguments:

  • Number     Required. The binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two’s-complement notation.

Example: Let’s look at some Excel BIN2DEC function examples and explore how to use the BIN2DEC function as a worksheet function in Microsoft Excel:

BIN2DEC Function - How to use BIN2DEC Function in Excel

Syntax:  =BIN2DEC(A2)

Result:

BIN2DEC Function in Excel - How to use BIN2DEC Function in Excel

Based on the Excel spreadsheet above, the following BIN2DEC examples would return:

Syntax: =BIN2DEC(A3)
Result: 2

Syntax: =BIN2DEC(A4)
Result: 4

Syntax: =BIN2DEC(A5)
Result: 7

Syntax: =BIN2DEC(A6)
Result: 100

Syntax: =BIN2DEC(A7)
Result: 511

Syntax: =BIN2DEC(A8)
Result: 508

Syntax: =BIN2DEC(A9)
Result: 510

Syntax: =BIN2DEC(A10)
Result: -342

Syntax: =BIN2DEC(A11)
Result: 5

Syntax: =BIN2DEC(A12)
Result: #NUM!

Syntax: =BIN2DEC(A13)
Result: #NUM!

Note:

  1. Numbers can be given as argument to the function directly without quotes or cell reference in excel.
  2. The number must be a valid binary numeric number.
  3. If the input number has less than 10 digits, the function takes 0s to the left of the number to complete its 10 character binary value.
  4. The function returns the max value of 511 & minimum value upto -512 (only integers).
  1. The function returns the #NUM! Error
    1. If the input characters exceed by 10 digits.
    2. If the input number is not a valid binary expression.
    3. If the input value is text or non-numeric.
    4. If the input number have fraction part or decimal part for example: 010111.101

Add a Comment

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