Difference between revisions of "Manuals/calci/HEX2DEC"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
HEX2DEC(number) | HEX2DEC(number) | ||
| − | For example, | + | For example, |
| − | + | HEX2DEC("F") ''returns 15'' as a result. | |
| + | |||
| + | HEX2DEC("01D") ''returns 29'' as a result. | ||
*This function is used to convert a hexadecimal number to a decimal number. | *This function is used to convert a hexadecimal number to a decimal number. | ||
*Hexadecimal number uses digits from 0 to 9 and characters from A to F. The number can also be entered in text format (e.g "1F"). | *Hexadecimal number uses digits from 0 to 9 and characters from A to F. The number can also be entered in text format (e.g "1F"). | ||
*A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers. | *A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers. | ||
| − | *A number can be up to 10 characters (40 bits). The most significant bit is the sign bit and remaining are magnitude bits. | + | *A number can be up to 10 characters (40 bits). The most significant bit is the sign bit and remaining are magnitude bits. A negative number is represented in 2's complement format. |
*If the number is not a valid number, 'Calci' returns an #ERROR message. | *If the number is not a valid number, 'Calci' returns an #ERROR message. | ||
| Line 25: | Line 27: | ||
1)SUM(HEX2DEC("FF") + HEX2DEC("57")) ''returns 342'' as a result. | 1)SUM(HEX2DEC("FF") + HEX2DEC("57")) ''returns 342'' as a result. | ||
| − | 2)HEX2DEC("65")- HEX2DEC("42") ''returns 35'' as a result. | + | 2)HEX2DEC("65") - HEX2DEC("42") ''returns 35'' as a result. |
== Examples == | == Examples == | ||
| Line 52: | Line 54: | ||
| class="sshl_f" | -1 | | class="sshl_f" | -1 | ||
|} | |} | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/DEC2HEX| DEC2HEX]] | ||
| + | |||
| + | *[[Manuals/calci/HEX2BIN| HEX2BIN]] | ||
| + | |||
| + | *[[Manuals/calci/HEX2OCT| HEX2OCT]] | ||
| + | |||
| + | *[[Manuals/calci/BIN2HEX| BIN2HEX]] | ||
| + | |||
| + | *[[Manuals/calci/OCT2HEX| OCT2HEX]] | ||
| + | |||
| + | ==References== | ||
| + | *[http://simple.wikipedia.org/wiki/Hexadecimal_numeral_system#Hexadecimal_and_decimal Hexadecimal to Decimal Conversion] | ||
Revision as of 15:53, 4 December 2013
HEX2DEC(number, places)
places argument to be included in upcoming version
- Where 'number' is the hexadecimal number to be converted to decimal number.
HEX2DEC() converts a hexadecimal number to a decimal number.
Description
HEX2DEC(number)
For example,
HEX2DEC("F") returns 15 as a result.
HEX2DEC("01D") returns 29 as a result.
- This function is used to convert a hexadecimal number to a decimal number.
- Hexadecimal number uses digits from 0 to 9 and characters from A to F. The number can also be entered in text format (e.g "1F").
- A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers.
- A number can be up to 10 characters (40 bits). The most significant bit is the sign bit and remaining are magnitude bits. A negative number is represented in 2's complement format.
- If the number is not a valid number, 'Calci' returns an #ERROR message.
Below are few examples that show the use of combination of functions and get the result in decimal -
1)SUM(HEX2DEC("FF") + HEX2DEC("57")) returns 342 as a result.
2)HEX2DEC("65") - HEX2DEC("42") returns 35 as a result.