Converts an octal number to binary.
Cú pháp
OCT2BIN(number, [places])Đối số
numberbắt buộc
The octal number you want to convert, limited to 10 characters.
placestùy chọn
The number of characters to use in the output, useful for padding.
The OCT2BIN function converts an octal number into its binary representation. If the optional places argument is provided, the function will pad the result with leading zeros to match the specified length.
=OCT2BIN(12)→1010Converts the octal number 12 to the binary 1010.
=OCT2BIN(5, 4)→0101Converts 5 to binary and pads it to 4 digits.
Select a cell
Click on the cell where you want to display the binary result.
Enter the formula
Type =OCT2BIN( followed by the octal number and optionally the number of places.
Press Enter
Press Enter to calculate and view the binary conversion.
The octal number cannot exceed 10 characters in length.
The function returns a #NUM! error.