|
|
Line 1: |
Line 1: |
− | {{Documentation/MasterTOC | + | {{DISPLAYTITLE:HEX2DEC function}} |
− | |bookid=1234'''
| + | {{Documentation/CalcFunc Number ConvTOC |
− | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
| + | |ShowPrevNext=block |
− | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Number_Conversion_functions|<div style="font-size: 140%;">Number Conversion Functions]]
| + | |PrevPage=Documentation/How_Tos/Calc:_HEX2BIN_function |
− | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_HEX2OCT_function | + | |NextPage=Documentation/How_Tos/Calc:_HEX2OCT_function |
− | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_HEX2BIN_function
| + | }}__NOTOC__ |
− | |ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Mathematical_functions | + | |
− | |ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Spreadsheet_functions
| + | |
− | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
| + | |
− | | + | |
− | * [[Documentation/How_Tos/Calc:_BIN2DEC_function|<div style="font-size: 120%;">Bin2dec]]
| + | |
− | * [[Documentation/How_Tos/Calc:_BIN2HEX_function|<div style="font-size: 120%;">Bin2hex]]
| + | |
− | * [[Documentation/How_Tos/Calc:_BIN2OCT_function|<div style="font-size: 120%;">Bin2oct]]
| + | |
− | * [[Documentation/How_Tos/Calc:_DEC2BIN_function|<div style="font-size: 120%;">Dec2bin]]
| + | |
− | * [[Documentation/How_Tos/Calc:_DEC2HEX_function|<div style="font-size: 120%;">Dec2hex]]
| + | |
− | * [[Documentation/How_Tos/Calc:_DEC2OCT_function|<div style="font-size: 120%;">Dec2oct]]
| + | |
− | * [[Documentation/How_Tos/Calc:_HEX2BIN_function|<div style="font-size: 120%;">Hex2bin]]
| + | |
− | * [[Documentation/How_Tos/Calc:_HEX2DEC_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Hex2dec]]
| + | |
− | * [[Documentation/How_Tos/Calc:_HEX2OCT_function|<div style="font-size: 120%;">Hex2oct]]
| + | |
− | * [[Documentation/How_Tos/Calc:_OCT2BIN_function|<div style="font-size: 120%;">Oct2bin]]
| + | |
− | * [[Documentation/How_Tos/Calc:_OCT2DEC_function|<div style="font-size: 120%;">Oct2dec]]
| + | |
− | * [[Documentation/How_Tos/Calc:_OCT2HEX_function|<div style="font-size: 120%;">Oct2hex]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ARABIC_function|<div style="font-size: 120%;">Arabic]]
| + | |
− | * [[Documentation/How_Tos/Calc:_BAHTTEXT_function|<div style="font-size: 120%;">Bahttext]]
| + | |
− | * [[Documentation/How_Tos/Calc:_DECIMAL_function|<div style="font-size: 120%;">Decimal]]
| + | |
− | * [[Documentation/How_Tos/Calc:_ROMAN_function|<div style="font-size: 120%;">Roman]]
| + | |
− | }}__TOC__ | + | |
| | | |
| == HEX2DEC == | | == HEX2DEC == |
Line 34: |
Line 13: |
| === Syntax: === | | === Syntax: === |
| <tt>'''HEX2DEC(hexadecimalnumber)'''</tt> | | <tt>'''HEX2DEC(hexadecimalnumber)'''</tt> |
− | : returns a (decimal) number, given <tt>'''hexadecimalnumber'''</tt>, which may be text, or a number (taken to be hexadecimal although it is not). | + | : returns a (decimal) number, given <tt>'''hexadecimalnumber'''</tt>, which may be text, or a number (taken to be hexadecimal, although it is not). |
| | | |
| : <tt>'''hexadecimalnumber'''</tt> may have up to ten digits in two's complement representation; positive numbers are 0 to 7FFFFFFFFF (representing 0 to 2<sup>39</sup>-1 decimal) and negative numbers FFFFFFFFFF to 8000000000 (representing -1 to -2<sup>39</sup> decimal). | | : <tt>'''hexadecimalnumber'''</tt> may have up to ten digits in two's complement representation; positive numbers are 0 to 7FFFFFFFFF (representing 0 to 2<sup>39</sup>-1 decimal) and negative numbers FFFFFFFFFF to 8000000000 (representing -1 to -2<sup>39</sup> decimal). |
Line 49: |
Line 28: |
| | | |
| <tt>'''HEX2DEC(20)'''</tt> | | <tt>'''HEX2DEC(20)'''</tt> |
− | : returns <tt>'''32'''</tt> as a (decimal) number. The number <tt>'''20'''</tt> is read as hexadecimal. This is not recommend since changing the parameter to '''1F''' without double quotes will result in HEX2DEC converting the parameter to '''F1''' and doing a cell lookup. | + | : returns <tt>'''32'''</tt> as a (decimal) number. The number <tt>'''20'''</tt> is read as hexadecimal. This is not recommended since changing the parameter to '''1F''' without double quotes will result in HEX2DEC converting the parameter to '''F1''' and doing a cell lookup. |
| | | |
| {{SeeAlso|EN| | | {{SeeAlso|EN| |