Converts a binary number to octal.
구문
BIN2OCT(number, [places])인수
number필수
The binary number you want to convert, provided as a string or number.
places선택
The number of characters to use in the output; pads with leading zeros if necessary.
The BIN2OCT function converts a binary string into its octal equivalent. If the number is negative, it is represented in two's-complement notation.
=BIN2OCT("1100100")→144Converts the binary 1100100 to the octal value 144.
=BIN2OCT("101", 4)→0005Converts binary 101 to octal 5, padded to 4 characters.
Enter the function
Type =BIN2OCT( into the desired cell.
Specify the binary number
Enter the binary number as a string in quotes or reference a cell containing it.
Set optional padding
Add the optional places argument if you need a specific number of digits.
The number argument cannot contain more than 10 characters (10 bits).
This usually happens if the binary number is invalid or exceeds the 10-bit limit.