BIN2OCT Function

The BIN2OCT function is used to convert a binary number to an octal number.

Formula:


=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.

Video Tutorial:


Let us convert a binary number to an octal number, using the BIN2OCT function, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question