HEX2DEC Excel Formula
Do you use Microsoft Excel in your engineering computation? Well, if yes, you must learn the different functions of Excel. For such reasons, it will let you learn and use the program in such an easy way. Excel has different functions when it comes to converting value related to engineering computation and one of these functions is HEX2DEC. Though HEX2DEC is seldom use, but still it is important to know its function and purpose just in case you will need it eventually for excel.
HEX2DEC Definition
This is the function that alters hexadecimal number to decimal integer. A hexadecimal number has 16 characters or bits. The hexadecimal value in this function is represented by a string called varchar and changes it to 64-number signed known as bigint.
HEX2DEC Microsoft Excel Formula
When doing HEX2DEC function, user must observe the formula:
=HEX2DEC(number)
In the formula the number is the hexadecimal value desired to alter to decimal figure. In the function, the hexadecimal integer wish to change must not go beyond 40 bits or ten characters. The most important bit of the figure is identified as the sign bit and the residual 39 bits are the identified as magnitude bits. Once the value is in negative form it must be expressed in two compliment note.
Notes
Listed Below are the Key Pointers in Using HEX2DEC Function:
- The type in argument should be considered as legitimate hexadecimal value, otherwise there will be an exception that will be thrown.
- The hexadecimal numbers that is in the compelling range must be embodied by strings of maximum 16 characters with no optional ‘0x’ prefix or until 18 characters, which include the ‘0x’ prefix. In this function leading zeros are no longer needed.
- Hexadecimal figures are not totally case sensitive and lower, upper or combination of cases is all accepted.
- It is important to take note that HEX2DEC function must be utilized with string symbols of hexadecimal values for instance nvarchar, varchar. Once you employ a literal hexadecimal without placing it within quotes then it will be read as SQL, as a number directly and it is no longer required to utilize conversion function.
- The least and utmost conversion sort is from -9,223,372,036,854,775,808 unto +9,223,372,036,854,775,807. In hexadecimal the numbers are written as 0×8000000000000000 up to 0x7fffffffffffffff.
Examples:
=HEX2DEC(1) = 1
=HEX2DEC(“1″) = 1
=HEX2DEC(“01″) = 1
=HEX2DEC(“001″) = 1
=HEX2DEC(“2″) = 2
=HEX2DEC(“E”) = 14
=HEX2DEC(“FB”) = 251
=HEX2DEC(“1FF”) = 511
=HEX2DEC(“A5″) = 165
=HEX2DEC(“FFFFFFFF5B”) = -165
=HEX2DEC(“3D8B9″) = 252089
=HEX2DEC(“FFFFFFFFF”) = 68719476735
=HEX2DEC(“FFFFFFFFFF”) = -1
=HEX2DEC(“FFFFFFFFFFF”) = #NUM!
=HEX2DEC(“-200″) = #NUM!
=HEX2DEC(“HIJKLMN”) = #NUM!
=HEX2DEC(“some text”) = #NUM!
These are the example that you could try on your worksheet. To understand it more, begin inputting data from A1 cell to acquire the same result.
It is also important to always remember that once the number you keyed in is more than 10 characters or is not a legitimate hexadecimal number, the answer will appear as #NUM! error value. Additionally, make sure to convert hexadecimal number between double quotes HEX2DEC function.
Further readings
Post comment
Categories
Recent Posts
- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro
Random Posts
- PEARSON Excel Formula
- WORKDAY Excel Formula
- HEX2BIN Excel Formula
- HEX2COT Excel Formula
- SKEW Excel Formula
- PI Excel Formula
- How to Update the Data in a Pivot Table
- How to Edit a Recorded Macro?
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- ODDFYIELD Excel Formula