Calc HEX2OCT function

The HEX2OCT function converts a hexadecimal number to its octal equivalent.

Help CentreFunctions & Formulas

For a full list of available calculation functions, please read What calculation functions are supported.


Description

The HEX2OCT function converts a hexadecimal number to its octal equivalent. This is useful in various applications, especially in computing and digital electronics, where octal representation is sometimes used.


Syntax

HEX2OCT(number, [places])


The HEX2OCT function syntax has the following arguments:

  • number Required. The hexadecimal number you want to convert to octal. It must be a valid hexadecimal string.
  • places Optional. The number of characters to use for the octal result. If omitted, the function returns the minimum number of characters necessary to represent the number in octal.

Example

FormulaDescriptionResult
=HEX2OCT("A")Converts the hexadecimal number "A" to octal.12
=HEX2OCT("FF")Converts the hexadecimal number "FF" to octal.377

Errors

For a full list of formula errors, please read Formula errors.


Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.