Difference between revisions of "Documentation/How Tos/Calc: HEX2DEC function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m (→Syntax:) |
m |
||
| (6 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | __NOTOC__ | + | {{DISPLAYTITLE:HEX2DEC function}} |
| + | {{Documentation/CalcFunc Number ConvTOC | ||
| + | |ShowPrevNext=block | ||
| + | |PrevPage=Documentation/How_Tos/Calc:_HEX2BIN_function | ||
| + | |NextPage=Documentation/How_Tos/Calc:_HEX2OCT_function | ||
| + | }}__NOTOC__ | ||
== HEX2DEC == | == HEX2DEC == | ||
| Line 8: | 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 | + | : <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). |
=== Example: === | === Example: === | ||
| Line 23: | 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 | + | : 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| |
* [[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]] | * [[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]] | ||
* [[Documentation/How_Tos/Calc: BIN2HEX function|BIN2HEX]] | * [[Documentation/How_Tos/Calc: BIN2HEX function|BIN2HEX]] | ||
| Line 44: | Line 49: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
| + | [[Category: Documentation/Reference/Calc/Number Conversion functions]] | ||
