# A to Z of Excel Functions: the OCT2BIN Function

27 March 2023

*Welcome
back to our regular A to Z of Excel Functions blog. Today we look at the OCT2BIN function. *

** **

**The
OCT2BIN function**

This function converts an octal number (base eight) to a binary number (base two).

The **OCT2BIN **function
employs the following syntax to operate:

**OCT2BIN(number,
[places])**

The **OCT2BIN**function has the following arguments:

**number**:**number**cannot contain more than 10 octal characters (30 bits) and that the most significant bit of**number**is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using**two's complement**notation**places**:**places**is omitted,**OCT2BIN**uses the minimum number of characters necessary. The argument**places**is useful for padding the return value with leading 0s (zeroes).

**Two's
complement** is a mathematical operation on binary numbers, as well as a binary
signed number representation based on this operation. The two's complement of an **N**-bit number is defined as the
complement with respect to 2** ^{N}**;
in other words, it is the result of subtracting the number from 2

**. This is also equivalent to taking the ones' complement and then adding one, since the sum of a number and its ones' complement is all 1 bits. The two's complement of a number behaves like the negative of the original number in most arithmetic, and positive and negative numbers can coexist in a natural way.**

^{N}It should be further noted that:

- if
**number**is negative,**OCT2BIN**ignores**places**and returns a 10-character binary number - if
**number**is negative, it cannot be less than 7777777000, and if**number**is positive, it cannot be greater than 777 - If
**number**is not a valid octal number,**OCT2BIN**returns the*#NUM!*error value - if
**OCT2BIN**requires more than**places**characters, it returns the*#NUM!*error value - if
**places**is not an integer, it is truncated - if
**places**is nonnumeric,**OCT2BIN**returns the*#VALUE!*error value - if
**places**is negative,**OCT2BIN**returns the*#NUM!*error value.

Please see my example below:

*We’ll continue our A
to Z of Excel Functions soon. Keep
checking back – there’s a new blog post every other business day.*