Excel OCT2BIN Function

If you want to follow along with this tutorial, please download the example spreadsheet.

Description

The Excel OCT2BIN function converts an octal number to a binary number.

Syntax and arguments

Formula syntax

Arguments

Return Value

The OCT2BIN function returns a binary number.

Error

1. Return #NUM! error if one of the below states occurs:

• Argument number is > 777 or < 7777777000;
• Argument places is provided not enough for the argument number, such as OCT2BIN(“21”,2) returns #NUM!, because the correct result is 10001;
• Argument places is < = 0.

2. Return #VALUE! error if argument places is a non-numeric value.

Version

Excel 2003 and later versions

Usage and Examples

Example

There is a list of octal numbers placed in C4:C10, to get the corresponding binary numbers based on the places in D4:D10, please copy or enter the below formula to the next cell of the range:

=OCT2BIN(C4,D4)

Press Enter key and drag the auto-fill handle down to get all binary numbers.

If you just use the formula once, you also can directly type arguments in the formula:

=OCT2BIN(0,1)

Relative Functions:

• Excel BIN2DEC Function
  The BIN2DEC function converts a binary number to a decimal number.

• Excel BIN2HEX Function
  The BIN2HEX function converts a binary number to a hexadecimal number.

• Excel BIN2OCT Function
  The BIN2OCT function converts a binary number to an octal number.

• Excel HEX2DEC Function
  The Excel HEX2DEC function converts a hexadecimal number to a decimal integer number.