HEX2OCT Function

You can convert hexadecimal numbers into octal numbers
The hexadecimal numbers contain only 0 and F values
Octal numbers contain 0 to 7 values

OCT2HEX Function has a limit of ten times of "F" hexadecimal numbers
If you write more than ten times "F" characters it will return #NUM error

Syntax

=HEX2OCT(number)

Argument

Number: it is the number you want to convert into octal numbers

Behavior

Here we have taken an example of the hexadecimal number and convert it into octal numbers.
We have written a formula  

=HEX2OCT(D4) which will convert the hexadecimal number into octal

On the right side, if you write ten times "F" it will return "7777777777"
If you write more than ten times "F" it will return #NUM error

Usage

To convert a Hexadecimal number into a OCtal number

Returns

Octal number