ID EN
…
#Engineering

OCT2BIN

Excel Functions

Convert octal number to binary

Syntax

EXCEL 
=OCT2BIN(number, [places])

Arguments

Parameter Description
number The octal number you want to convert.
places [optional] The number of characters to use. If omitted, the function uses the minimum number of characters necessary.

Return Value

Binary number

Details

The OCT2BIN function is used to convert octal numbers (base 8) to binary numbers (base 2). This is useful when working with different number systems, especially in engineering and computer science applications. To convert the octal number 11 to binary, use the following formula: To convert the octal number 11 to binary, padded to 10 characters, use the following formula: Excel represents negative numbers in non-decimal bases (like octal and binary) using two's complement notation with a fixed width of 10 characters. This means that when you use OCT2BIN with a negative octal number, Excel interprets the input as a two's complement value and returns a 10-character binary string. For example, to represent the decimal number -3 in octal, you would use the octal number 7777777775. This is becau

Examples

Example #1 - Basic conversion

To convert the octal number 11 to binary, use the following formula:

EXCEL 
=OCT2BIN(11) // returns 1001 (binary)
Example #2 - Padding with leading zeros

To convert the octal number 11 to binary, padded to 10 characters, use the following formula:

EXCEL 
=OCT2BIN(11, 10) // returns 00000001001 (binary)
Example #3 - Negative octal numbers

For example, to represent the decimal number -3 in octal, you would use the octal number 7777777775. This is because the most significant digit is the

EXCEL 
=DEC2OCT(-3) // returns 7777777775
Example #3 - Negative octal numbers

Then, when we convert the octal number to binary, we get the following result:

EXCEL 
=OCT2BIN(7777777775) // returns 1111111101

See Also

DEC2OCT OCT2DEC OCT2HEX