EXCEL OCT2HEX FUNCTION

The Oct2Hex function in Excel transforms an Octal (Base 8) value to a Hexadecimal (Base 16) number.

Syntax :

=OCT2HEX( number[places] )

Parameters :

  • Number – The octal value to be translated to hexadecimal.
  • Places – An optional parameter that determines the amount of characters in the returned hexadecimal number. If this value is more than zero, the hexadecimal number will be padded with leading zeros. If omitted, the returned hexadecimal utilises the fewest possible places.

Step By Step Guide of OCT2HEX Function

Example :

The negative octal and hexadecimal integers in cell A4 in the above example spreadsheet are represented by two’s complement notation.

  • #NUM! – Occurs if the given number argument is not accepted as an octal number or contains and over 10 characters. The generated hexadecimal number requires more places than the [places] input specifies. The given [places] parameter is 0 or greater than 10.
  • #VALUE! – This error occurs if the given [places] parameter is not a number.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now