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

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