OCT2BIN Function

The OCT2BIN () is an engineering function which takes number and places as argument and converts an octal number to a binary number.

Formula:


=OCT2BIN(number,places)
In the above syntax, the argument number denotes the octal number to be converted .The "Number" should not be more than 10 digits. The most significant bit is sign bit and the remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation. Places denote the number of characters to use. If places is omitted, OCT2BIN function uses the minimum number of characters necessary.

Video Tutorial:


Let us see how the OCT2BIN function converts an octal number to a binary number with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question