Difference between revisions of "Documentation/How Tos/Calc: HEX2DEC function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
Javier Lopez (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | + | {{Documentation/MasterTOC | |
| + | |bookid=1234''' | ||
| + | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | ||
| + | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Number_Conversion_functions|<div style="font-size: 140%;">Number Conversion Functions]] | ||
| + | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_HEX2OCT_function | ||
| + | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_HEX2BIN_function | ||
| + | |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 == | ||
Revision as of 18:21, 1 June 2013
CALC FUNCTIONS
- Number Conversion Functions
- Bin2decBin2hexBin2octDec2binDec2hexDec2octHex2binHex2decHex2octOct2binOct2decOct2hexArabic
Contents
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 recommend since changing the parameter to 1F without double quotes will result in HEX2DEC converting the parameter to F1 and doing a cell lookup.
-
