# OCT2HEX Excel Formula Zaheer Formulas , ,

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.

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.