You can convert octal numbers into hexadecimal numbers

The hexadecimal numbers contain only 0 and F values

Octal numbers contain 0 to 7 values

OCT2HEX Function has a limit of 777 octal numbers

If you write more than 777 characters it will return #NUM error

###
*Syntax of OCT2HEX Function*

=OCT2HEX(number,[places])

###
*Argument** of OCT2HEX Function*

Number: it is the number you want to convert into hexadecimalPlaces:[Optional] how many characters you want to show in your result. It will place "0" before the result.

###
*Behavior** of OCT2HEX Function*

We have written a formula

=OCT2HEX(D4,5) which will convert the octal number into hexadecimal and show result till 5 characters. No character place is filled by 0

On the right side, if you write 777 it will return "1FF:

If you write 778 it will return #NUM error

## No comments:

## Post a Comment