HEX2OCT Function

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

Formula:


=HEX2OCT(number, places)
In the above syntax, the argument number denotes the hexadecimal number to be converted .The "Number" should not be more than 10 digits. The first bit is sign bit and the remaining 39 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, HEX2OCT uses the minimum number of characters necessary.

Video Tutorial:


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

Learn MS Excel


Ask Questions

Ask Question