# HEX2OCT

The `HEX2OCT` function converts a signed hexadecimal number to signed octal notation. This is commonly used in engineering calculations that require conversion of hexadecimal numbers to octal. The function takes a signed hexadecimal number as input and returns a signed octal number as output.

## Usage

Use the `HEX2OCT` formula with the syntax shown below, it has 2 required parameters:

Parameters:
The signed hexadecimal number to be converted to signed octal notation.
2. significant_digits (required):
The number of significant digits to include in the output, which must be between 1 and 10.

## Examples

Here are a few example use cases that explain how to use the `HEX2OCT` formula in Google Sheets.

### Converting hexadecimal numbers in engineering calculations

In engineering calculations, it is often necessary to convert hexadecimal numbers to octal. The `HEX2OCT` function makes this conversion easy and accurate.

### Creating custom number formats

The `HEX2OCT` function can be used in custom number formats to display numbers in signed octal notation.

### Converting large sets of data

The `HEX2OCT` function can be used in combination with other functions to quickly and easily convert large sets of data from hexadecimal to octal notation.

## Common Mistakes

`HEX2OCT` not working? Here are some common mistakes people make when using the `HEX2OCT` Google Sheets Formula:

The signed_hexadecimal_number argument must be a text string that represents a signed hexadecimal number. If it is not formatted correctly, the formula will return an error. Make sure the argument is in the correct format.

### Invalid significant_digits argument

The significant_digits argument must be a number between 1 and 10, inclusive. If it is not within this range, the formula will return an error. Make sure the argument is a valid number within the specified range.

The following functions are similar to `HEX2OCT` or are often used with it in a formula:

• `DEC2OCT`

The `DEC2OCT` function is an Engineering function in Google Sheets that converts a decimal number to an octal number. The octal number is returned as a text string. The function is most commonly used to convert decimal numbers to octal numbers for use in various calculations and data analysis tasks.

• `OCT2DEC`

The `OCT2DEC` function converts a signed octal number to its decimal equivalent. It takes one required parameter, the signed_octal_number, which is the signed octal number you want to convert to decimal. The function returns the decimal equivalent of the signed octal number.

• `HEX2DEC`

The `HEX2DEC` function converts a signed hexadecimal number to its decimal equivalent. This function is commonly used in engineering calculations where hexadecimal numbers are used to represent signed values.

• `DEC2HEX`

The `DEC2HEX` formula is an engineering formula in Google Sheets that converts a decimal number to its hexadecimal equivalent. It is commonly used to convert numbers to a format that is easier to read and work with in certain applications.

You can learn more about the `HEX2OCT` Google Sheets function on Google Support.