HEX2OCT
TheHEX2OCT
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.
 How to use
HEX2OCT
formula?  Examples of using
HEX2OCT
formula HEX2OCT
formula not working? Similar formulas to
HEX2OCT
Usage
Use the HEX2OCT
formula with the syntax shown below, it has 2 required parameters:
 signed_hexadecimal_number (required):
The signed hexadecimal number to be converted to signed octal notation.  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 theHEX2OCT
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:
Incorrectly formatted signed_hexadecimal_number
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.
Related Formulas
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.
Learn More
You can learn more about the HEX2OCT
Google Sheets function on Google Support.