Learn Excel - Simplify Life with Excel Concepts

## Excel BIN2OCT Function ### How to use the BIN2OCT Function

This Excel tutorial explains how to use the Excel BIN2OCT function with syntax and examples.

### SUMMARY:

The Excel BIN2OCT function converts a binary number to a octal number. The input number must contain only zeros and ones and be less than 10 characters long, otherwise the function returns the #NUM! error value.

For example,

• The formula =BIN2OCT(1101, 4) would return 0015
• The formula =BIN2OCT(1101100) would return 154

### PURPOSE:

To converts a binary number to Octal.

### RETURN VALUE:

The BIN2OCT function returns a Octal number type.

### SYNTAX:

=BIN2OCT(number, [places])

### ARGUMENTS:

The BIN2OCT function syntax has the following arguments:

• number: Required. The binary number you want to convert to octal.
• Number cannot contain more than 10 characters (10 bits).
• The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits.
• Negative numbers are represented using two's-complement notation.
• places: Optional. It specifies the number of characters that you want the returned octal number to have.
• If this is greater than the minimum, the hexadecimal number will be padded out using leading zeros.
• If omitted, the returned BIN2OCT uses the minimum number of places.
• If places is nonnumeric, BIN2OCT returns the #VALUE! error value.
• If places is negative, BIN2OCT returns the #NUM! error value.
• If places is not an integer, it is truncated.
• Places is useful for padding the return value with leading 0s (zeros).

### REMARKS:

• Negative numbers are represented using two's-complement notation.
• If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2OCT returns the #NUM! error value.
• If number is negative, BIN2OCT ignores places and returns a 10-character octal number.
• If BIN2OCT requires more than places characters, it returns the #NUM! error value.
• If places is not an integer, it is truncated.