OCT2BIN Excel Formula

Author Zaheer    Category Formulas     Tags ,


Hexadecimals base 16, decimals base ten, octal base eight, and the binary base 2 numbering systems are commonly used in computer science and engineering. Thus, Excel has provided function to change the numerical values ??of each of the systems. The function transfers an Excel file OCT2BIN octal base 8 in a binary system base 2 numbers.


The configuration of this particular function is as follows:

= OCT2BIN (number, [places])

It is


- The number of arguments is the octal binary becomes


- The arguments are not optional arguments specifying the numbers of character as the binary number repurchased. In case this is more than the least, then the binary number is padded with the use of leading 0.

If omitted, returns the binary number by using the least number of seats.

Note down that number of argument should not exceed 10 characters or 40 bits long. Most noteworthy bit of the value indicates the number sign and the left behind 39 bits indicate the extent. Negative statistics are represented using two different complement notations.

Some Vital Examples:

In this following example, the IMSUM excel function is being used to determine the sum of several different complex numbers.

The functions are displayed in the worksheet to the left along with the outcomes are revealed in the worksheet that is to the right.

Formulas:                                          Results:

=OCT2BIN (“5”)                               101

=OCT2BIN (“0000000001”)             1

=OCT2BIN (“2″, 10)                          0000000010

=OCT2BIN (“7777777770”)             1111111000

=OCT2BIN (“16”)                             1110


You have to remember that the above sample spreadsheet, binary numbers and negative octal the in the samples are represented by 2 complement notation.

For more information about OCT2BIN function in Excel, you can visit Microsoft Office site.

Common Errors in Excel OCTO2BIN Function:

In case you get the error from the IMSUB function in excel, it would be possible be any one of these:

  • #NUM! – It happens when supplied NUMBER argument isn’t identified as the complex number
  •    When supplied Place argument is ? 0
  •    resulting binary numbers needs more places than the specified supplied Places argument
  • #VALUE! – It occurs when supplied PLACES arguments isn’t recognized as a number
  • #NAME? – It turns out when the Analysis Tool Pak adds on is not capable in the Excel. You are needed to have allowed the add-on if you like to utilize Excel engineering functions.

For you to do it in Excel version 2003, you have to do the following:

  • From Tools drop down list of options, you have to choose the option Analysis Tool Pak and then click OK.
  • An add-on option will pop out and from here, you need to choose the option Analysis Tool Pal and then click OK.

For you to do it in Excel version 2007, you have to do the following:

  • Click Microsoft button just on top of the left spreadsheet and then choose Excel Option button
  • From Menu, select Add on located at the left side
  • In Manage box, you have to choose Excel Add- In and then click GO
  • An Add-on option will pop out. From here, you have to choose option Analysis Tool Pak and then click OK

Post comment