Difference between revisions of "Documentation/How Tos/Calc: HEX2DEC function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎See also:: DECIMAL fn)
m
 
(11 intermediate revisions by 7 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 digit in twos 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).
  
 
=== Example: ===
 
=== Example: ===
 
<tt>'''HEX2DEC("1E")'''</tt>
 
<tt>'''HEX2DEC("1E")'''</tt>
 
: returns <tt>'''30'''</tt> as a (decimal) number.
 
: returns <tt>'''30'''</tt> as a (decimal) number.
−
 
−
<tt>'''HEX2DEC(20)'''</tt>
 
−
: returns <tt>'''32'''</tt> as a (decimal) number. The number <tt>'''20'''</tt> is read as hexadecimal.
 
  
 
<tt>'''HEX2DEC("FFFFFFFFFE")'''</tt>
 
<tt>'''HEX2DEC("FFFFFFFFFE")'''</tt>
 
: returns <tt>'''-2'''</tt> as a (decimal) number.
 
: returns <tt>'''-2'''</tt> as a (decimal) number.
  
−
=== See also: ===
+
<tt>'''HEX2DEC($B$10)'''</tt>
−
[[Documentation/How_Tos/Calc: BIN2DEC function|'''BIN2DEC''']],
+
: returns the contents of cell B10 as a (decimal) number.
−
[[Documentation/How_Tos/Calc: BIN2HEX function|'''BIN2HEX''']],
+
 
−
[[Documentation/How_Tos/Calc: BIN2OCT function|'''BIN2OCT''']],
+
<tt>'''HEX2DEC(20)'''</tt>
−
[[Documentation/How_Tos/Calc: DEC2BIN function|'''DEC2BIN''']],
+
: 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.
−
[[Documentation/How_Tos/Calc: DEC2HEX function|'''DEC2HEX''']],
+
 
−
[[Documentation/How_Tos/Calc: DEC2OCT function|'''DEC2OCT''']],
+
{{SeeAlso|EN|
−
[[Documentation/How_Tos/Calc: HEX2BIN function|'''HEX2BIN''']],
+
* [[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]]
−
[[Documentation/How_Tos/Calc: HEX2OCT function|'''HEX2OCT''']],
+
* [[Documentation/How_Tos/Calc: BIN2HEX function|BIN2HEX]]
−
[[Documentation/How_Tos/Calc: OCT2BIN function|'''OCT2BIN''']],
+
* [[Documentation/How_Tos/Calc: BIN2OCT function|BIN2OCT]]
−
[[Documentation/How_Tos/Calc: OCT2DEC function|'''OCT2DEC''']],
+
* [[Documentation/How_Tos/Calc: DEC2BIN function|DEC2BIN]]
−
[[Documentation/How_Tos/Calc: OCT2HEX function|'''OCT2HEX''']]
+
* [[Documentation/How_Tos/Calc: DEC2HEX function|DEC2HEX]]
 +
* [[Documentation/How_Tos/Calc: DEC2OCT function|DEC2OCT]]
 +
* [[Documentation/How_Tos/Calc: HEX2BIN function|HEX2BIN]]
 +
* [[Documentation/How_Tos/Calc: HEX2OCT function|HEX2OCT]]
 +
* [[Documentation/How_Tos/Calc: OCT2BIN function|OCT2BIN]]
 +
* [[Documentation/How_Tos/Calc: OCT2DEC function|OCT2DEC]]
 +
* [[Documentation/How_Tos/Calc: OCT2HEX function|OCT2HEX]]
 +
 
 +
* [[Documentation/How_Tos/Calc: DECIMAL function|DECIMAL]]
  
−
[[Documentation/How_Tos/Calc: DECIMAL function|'''DECIMAL''']]
+
* [[Documentation/How_Tos/Calc: Number Conversion functions|Number Conversion functions]]
  
−
'''[[Documentation/How_Tos/Calc: Number Conversion functions|Number Conversion functions]]'''
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 +
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Number Conversion functions]]

Latest revision as of 14:19, 1 February 2024

HEX2DEC

Converts a hexadecimal number to decimal.

This function is only available if the Analysis AddIn is installed.

Syntax:

HEX2DEC(hexadecimalnumber)

returns a (decimal) number, given hexadecimalnumber, which may be text, or a number (taken to be hexadecimal, although it is not).
hexadecimalnumber may have up to ten digits in two's complement representation; positive numbers are 0 to 7FFFFFFFFF (representing 0 to 239-1 decimal) and negative numbers FFFFFFFFFF to 8000000000 (representing -1 to -239 decimal).

Example:

HEX2DEC("1E")

returns 30 as a (decimal) number.

HEX2DEC("FFFFFFFFFE")

returns -2 as a (decimal) number.

HEX2DEC($B$10)

returns the contents of cell B10 as a (decimal) number.

HEX2DEC(20)

returns 32 as a (decimal) number. The number 20 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.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_HEX2DEC_function&oldid=259934"
Views
Personal tools
Navigation
Tools