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

## No comments:

## Post a Comment