Converts a binary number to octal.
Syntax
BIN2OCT(number,places)
Argument | Description | Remarks |
|---|
number | The binary number that you want to convert. The
number argument 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. | -
If
number is not a valid binary number, or if
number contains more than 10 characters (10 bits), this function returns the #NUM! error value.
-
If
number is negative, this function ignores
places and returns a 10-character number.
|
places | The number of characters to use. The
places argument is useful for padding the return value with leading 0s (zeros). | -
If this argument is omitted, this function uses the minimum number of characters necessary.
-
If this function requires more than
places characters, it returns the #NUM! error value.
-
If this argument contains a decimal value, this function ignores the numbers to the right side of the decimal point.
-
If this argument is nonnumeric, this function returns the #VALUE! error value.
-
If this argument is negative, this function returns the #NUM! error value.
|
Example
To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.
 | | 1 | | 2 | | 3 | | 4 |
| | A | B | | Formula | Description (Result) | | =BIN2OCT(1001,3) | Converts binary 1001 to octal with 3 characters (011) | | =BIN2OCT(1100100) | Converts binary 1100100 to octal (144) | |
=BIN2OCT(1111111111) | Converts binary 1111111111 to octal (7777777777) |
|
