OCT2HEX Function

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

Formula:


=OCT2HEX(number,places)
In the above syntax, the argument number denotes the octal number to be converted .The "Number" should not contain 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 denotes the number of characters to use. If places are omitted, OCT2HEX uses the minimum number of characters necessary.

Video Tutorial:


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

Learn MS Excel


Ask Questions

Ask Question