# OCT2BIN

### Definition of OCT2BIN

Converts a signed octal number to signed binary format.

### Sample Usage

`OCT2BIN(37,8)`

`OCT2BIN(A2)`

### Syntax

`OCT2BIN(signed_octal_number, [significant_digits])`

`xsigned_octal_number`

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

`signed_octal_number`

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

If

`signed_octal_number`

is provided as a valid octal number, it will automatically be converted to the appropriate string input. For example,`OCT2BIN(177)`

and`OCT2BIN("177")`

yield the same result:`1111111`

.

`significant_digits`

-**[**OPTIONAL**]**The number of significant digits to ensure in the result.If this is greater than the number of significant digits in the result, the result is left-padded with zeros until the total number of digits reaches

`significant_digits`

.This value is ignored if the most significant bit of

`signed_octal_number`

is`1`

; that is, if the expressed`signed_octal_number`

is greater than or equal to 4000000000.

### Notes

As with any octal value, only the digits 0-7 are valid. Digits outside of this will cause

`OCT2BIN`

to return a`#NUM!`

error.If the number of digits required is greater than the specified

`significant_digits`

, the`#NUM!`

error is returned.

### See Also

`OCT2HEX`

: Converts a signed octal number to signed hexadecimal format.

`OCT2DEC`

: Converts a signed octal number to decimal 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.

`BIN2DEC`

: Converts a signed binary number to decimal format.

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

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

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

**Error.**

User does not have sufficient privileges to access this Content

Learn More