# BIN2DEC

### Definition of BIN2DEC

Converts a signed binary number to decimal format.

### Sample Usage

`BIN2DEC(101)`

`BIN2DEC(A2)`

### Syntax

`BIN2DEC(signed_binary_number)`

`signed_binary_number`

- The signed 10-bit binary value to be converted to decimal, provided as a string.The most significant bit of

`signed_binary_number`

is the sign bit; that is, negative numbers are represented in two's complement format.For this function, the input value has a maximum of 0111111111 if positive, and a minimum of 1000000000 if negative.

If

`signed_binary_number`

is provided as a valid binary number, it will automatically be converted to the appropriate string input. For example,`BIN2DEC(100)`

and`BIN2DEC("100")`

yield the same result: 4.

### Notes

- As with any binary value, only the digits
`0`

and`1`

are valid. Digits other than these will cause`BIN2DEC`

to return a`#NUM!`

error.

### See Also

`OCT2HEX`

: Converts a signed octal number to signed hexadecimal format.

`OCT2DEC`

: Converts a signed octal number to decimal format.

`OCT2BIN`

: Converts a signed octal number to signed binary format.

`HEX2OCT`

: Converts a signed hexadecimal number to signed octal format.

`HEX2DEC`

: Converts a signed hexadecimal number to decimal format.

`HEX2BIN`

: Converts a signed hexadecimal number to signed binary format.

`DEC2OCT`

: Converts a decimal number to signed octal format.

`DEC2HEX`

: Converts a decimal number to signed hexadecimal format.

`DEC2BIN`

: Converts a decimal number to signed binary format.

`BIN2OCT`

: Converts a signed binary number to signed octal format.

`BIN2HEX`

: Converts a signed binary number to signed hexadecimal format.

### In order to use the BIN2DEC formula, start with your edited Excellentable:

### Then type in the BIN2DEC Formula in the area you would like to display the outcome:

### By adding the value you would like to calculate the BIN2DEC formula for, Excellentable will generate the outcome: