HEX2COT Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel is solely distributed by Microsoft which is a commercial spreadsheet. This software allows the user to do computations, graph and chart values, and use Visual Basic for Applications.

There are functions in Excel that could help the user do formulas and computations for different fields. This includes Data Functions, Information Functions, Logical Functions, Statistical Functions, Database Functions, Engineering Functions and many others. These functions are subdivided into different specific functions for you to immediately identify what to use.

For the Statistical Functions, you can do the usual engineering computations which ranges from Bessel Functions to the more complex like conversion of different bases. However, some of the Engineering Functions are not readily installed in the earlier versions of Microsoft Excel.

Before starting with the usage of HEX2COT function, make sure that it is permitted in your Microsoft Excel software to avoid error such as the #NAME? error. To enable first select the Tool in the menu bar and choose the Add-Ins. On the available Add-Ins selection choose the Analisys ToolPak option and hit OK.

The syntax of the HEX2COT function includes:

HEX2OCT (number,places)

…wherein Number argument refers to the value of the hexadecimal you like to convert. This argument must not contain over ten characters or 40 bits. The sign bits is the most vital bit and the thirty nine bits are considered magnitude bits. For negative numbers, these will be represented by the use of two’s-complement notations. The Place argument refers to the numbers of character you will be using. Moreover, the minimum necessary characters will be used if the Place argument will be left blank or will be omitted.

Try the HEX2COT function by opening first a blank Excel worksheet or spreadsheet. Input the following formulas; in cell A1 input the formula =HEX2OCT (“F”, 3) which means that you like to convert the hexadecimal F into octal with the characters of 3. The result of the formula will be 017. Another example is, input the formula =HEX2OCT (“3B4E”) in cell A1 then the result will be 35516. The formula means that you like to convert the 3B4E hexadecimal to an octal.

You can switch viewing from result to formula by selecting the cell first and hit the Ctrl+` (grave accent). Also, you can do its in Formula tan hit Formula Auditing groups and choose the Formulas option.

Take note that when the supplied Number arguments are negative the function will ignore the value and it will return to an octal number with ten characters. The common error that occurs inHEX2OCT function is #NUM! error and #VALUE! error. #NUM! error will occur if the given value in the Number arguments are an invalid hexadecimal value. Also, #NUM! error will occur if the value needs more place than the specific places and if the value of the Places of argument is negative. Lastly, if the given value of Places of argument isn’t an integer then it will abbreviate.

Post comment