OCT2HEX Excel Formula

Microsoft Excel is more useful and versatile that most individuals think. Even though MS Excel is well known spreadsheet software utilized mainly for managing, organizing, manipulating and analyzing data, it also has a huge capability for perform practical tasks. The strength of Microsoft Excel lies in its ability to rapidly organize, manage and sort through data. There are several ways in which a regular computer user could also use Excel to assist manage everyday assignments.

Moreover, Microsoft Excel is featured with powerful functions and formulas that are able to perform even more complex tasks that are useful for business, accounting, and in various fields like science, mathematics and engineering. These functions are beneficial especially for students and even for professionals in their respective fields. One of the functions that are featured in Excel that can be very useful especially in the field of engineering is the OCT2HEX function. One way to start learning about this function is to know its basic description. So, for better understanding about this function, read on this article.

Overview of the OCT2HEX Function in Excel

The most commonly utilized numeral systems in computing as well as in engineering are: binary (base2), octal (base8), decimal (base10) and hexadecimal (base 16). Thus, Microsoft Excel is offering functions for the conversion of numeric values to and from each of these numeral systems.

The OCT2HEX function in Microsoft Excel has the ability to convert an octal (base 8) numeric value into a hexadecimal (base 16) numeric value. The formula of the OCT2HEX function is:

OCT2HEX(number, [places])

The arguments are as follows:

  • In this formula, the number argument is the octal numeric value that you wish to convert into a hexadecimal number.
  • On the other hand, the [places] argument is optional. It indicates the number of characters that the returned hexadecimal numeric value will have. If the value of this argument is higher than the minimum, the returned hexadecimal numeric value will be padded out with the use of leading zeros. However, if this argument is omitted, the returned hexadecimal number will use the minimum number of places.

Note: The number argument should not be more than 10 characters (40 bits) long. The most important bit of this value represents the sign of the numeric value and the remaining 39 bits represent the magnitude. The two’s complement notation is used to represent negative numeric values.

Common Errors in the OCT2HEX Function

The following values will be displayed if you obtain an error from Excel’s OCT2HEX function:

  • #VALUE! – This value is displayed if the supplied [places] argument is not identified as a numeric value.
  • #NUM! – This value is displayed if either:

The supplied [places] argument is less than or equal to zero, or

The resulting hexadecimal numeric value needs more places than is indicated by the supplied [places] argument, or

The supplied number argument is not identified as an octal numeric value or contains characters that are more than 10.

  • #NAME! – This value is displayed when the Analysis ToolPak add-in is not activated in your Excel spreadsheet. Before you can use the engineering functions in Excel, you need to activate first the add-in.

Post comment