HEX2OCT Function

how to use hex2oct function in excel

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




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


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


To convert a Hexadecimal number into a OCtal number


Octal number

No comments:

Post a Comment