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.
Diffrent way to use the BIN2OCT function...
BIN2OCT Function Error:
- #NUM! error:
- If number is not a valid binary number, or if number contains more than 10 characters (10 bits).
BIN2OCT function returns the #NUM! error - The resulting octal number requires more places than is specified by the supplied [places] argument.
- The supplied [places] argument is < 0 or > 10.
- If number is not a valid binary number, or if number contains more than 10 characters (10 bits).
- #VALUE! error:
- Occurs if the supplied [places] argument is non-numeric.
