Excel HEX2OCT Function

If you want to follow along with this tutorial, please download the example spreadsheet.

Description

The Excel HEX2OCT function converts a hexadecimal number to an octal number.

Syntax and arguments

Formula syntax

Arguments

Return Value

The HEX2OCT function returns to an octal number.

Error

1. Return #NUM! error if one of below states occurs:

• Argument number is > FFE0000000 or < 1FFFFFFFFF or an invalid value;
• Argument places is provided not enough for the argument number, such as HEX2OCT(“1110”,2) returns #NUM!, because the correctly result is 10420.
• Argument places is < = 0.

2. Return #VALUE! error if argument places is a non-numeric values.

Version

Excel 2003 and later

Usage and Examples

Example: Basic Usage

There is a list of hexadecimal numbers placed in C4:C10, to get the corresponding octal numbers based on the places in D4:D10, please copy or enter the below formula to the next cell of the range:

=HEX2OCT(C4,D4)

Press Enter key and drag the autofill handle down to get all octal numbers.

If you just use the formula once, you also can directly type arguments in the formula:

=HEX2OCT(0,1)

Relative Functions:

• Excel DEC2BIN Function
  The Excel DEC2BIN function converts a decimal number to a binary number.

• Excel DEC2HEX.S Function
  The Excel DEC2BIN function converts a decimal number to a hex number.

• Excel DEC2OCT Function
  The Excel DEC2OCT function converts a decimal number to an octal number

• Excel HEX2DEC Function
  The Excel HEX2DEC function converts a hexadecimal number to a decimal integer number.