The BIN2OCT function is used to convert a binary number to an octal number.
=BIN2OCT(Number, Places) Whereas Number is the binary number to be converted and Places is the number of characters to use. The "Number" should not be more than 10 digits. The first bit is sign bit and the remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
Let us convert a binary number to an octal number, using the BIN2OCT function, with the help of the below video.