Excel BIN2OCT Function

Using the Excel BIN2OCT Function


The Excel BIN2OCT function converts a binary number to octal.


=BIN2OCT (number, [places])

Syntax Breakdown

Required. The number, in binary format, that you wish to convert to octal. Negative numbers are represented using two's-complement notation. Number must be less than 10 characters (10 bits).

If the number argument is negative, the function will ignore the places argument and return a 10-character octal value.

Optional. The number of characters to use. If omitted, the function uses the minimum number of places necessary. Entries that are not integers will be truncated.

Usage Notes

BIN2OCT converts a number from binary to its octal equivalent. The first bit indicates if the number is negative or positive. The remaining 9 digits represent the actual number.

BIN2OCT Errors
The function will return an error in the following instances:

1) The function returns the #NUM! error if number isn't a valid binary number or if number is greater than 10 characters (10 bits)

2) If the places argument is non-numeric, the function returns the #VALUE! error

3) If the places argument is negative, the function returns the #NUM! error