DEC2HEX Excel Formula

Microsoft Excel program is part of an engineer’s database. With this program, their computations are arranged and saved according to their desired output. Since Microsoft is a program that deals with correct formula to get appropriate result, the user must identify the numerous engineering functions for them to acquire right end result of figures. With regard to its various function, one of the functions that users need to fully understand is the DEC2HEX function.

DEC2HEX Basic Description

DEC2HEX function change decimal value to Hexadecimal figure or Base 16 character. This function requires Analysis ToolPak to enable it on the worksheet before starting to work to ensure that Excel will give the correct outcome.

DEC2HEX Function Format

The function formula is =DEC2HEX(number, places)

The Representation:

number – this is the value you would like to change. Figure must be in decimal integer. Once the value is in negative form, the place is overlooked and the value of DEC2HX goes back to 10 digits hexadecimal value in which the most essential value is identified as sign bit. The left 39 characters are called the magnitude bits.

places – this is the desired character numbers to utilize. Once there is no written value for places on the formula, then the Excel will use the least number of essential characters. The value of places is valuable in padding the return number with leading 0.

DEC2HEX Function Examples:

With this example start at A1 cells going down:

=DEC2HEX( 10 ) – A

=DEC2HEX( 31 ) – 1F – Result is  1*16 + 15

=DEC2HEX( 16, 10 ) – 0000000010 – Result is  1*16 + 0

=DEC2HEX( -16 ) – FFFFFFFFF0 – Result is  -16^9 + 15*16^8 + 15*16^7 + … + 15*16 + 0

=DEC2HEX( 273 ) – 111 -  Result is  1*16^2 + 1*16 + 1

The same thing with other function, there are several pointers needed to consider when using or performing the function. Here are the details that any user should pay attention to:

  • Once the value is less than 549, 755, 813, 888 or the value is greater than 549, 755, 813, 887, and then DEC2HEX function receives #NUM answer.
  • If ever the value is not in figure, the answer appears to be #VALUE.
  • Once DEC2HEX function needs larger places of characters, the outcome of the function is #NUM value.
  • The answer is reduced once the places are not an integer.
  • The same with number, if the place is not in figure value, the DEC2HX function acquires #VALUE result.
  • Once the places are in negative form #NUM value appears on the DEC2HX outcome.

As what is said earlier, DEC2HEX is efficiently utilized if the Analysis ToolPak is enabled. To do this, below are the step by step processes of enabling it:

  • From the worksheet, on the toolbar click “Tools” and then click “Add Ins”.
  • After clicking the Add Ins, click the Analysis ToolPak box from the list of “Add-Ins available”.
  • Click Ok. Now the program is enabled and the function is ready to be utilized.

Ensure that the program is enabled or installed before entering any kinds of data or inputting formula on the worksheet.

Post comment