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

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
 
(4 intermediate revisions by 3 users not shown)
Line 1: Line 1:
__NOTOC__
+
{{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:_BIN2OCT_function
 +
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_BIN2DEC_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%; border-style: double; border-color:#778899;">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%;">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__
  
 
== BIN2HEX ==
 
== BIN2HEX ==
Line 29: Line 55:
 
: returns <tt>'''FFFFFFFFFE'''</tt> as text (twos complement representation of decimal -2).
 
: returns <tt>'''FFFFFFFFFE'''</tt> as text (twos complement representation of decimal -2).
  
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]]
 
* [[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]]
 
* [[Documentation/How_Tos/Calc: BIN2OCT function|BIN2OCT]]
 
* [[Documentation/How_Tos/Calc: BIN2OCT function|BIN2OCT]]
Line 46: Line 72:
 
* [[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]]

Latest revision as of 08:06, 17 July 2018


BIN2HEX

Converts a binary number to hexadecimal.

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

Syntax:

BIN2HEX(binarynumber; numdigits)

returns text representing a hexadecimal number, given binarynumber, which may be text, or a number containing only digits 1 and 0 (thus the number appears to be binary although it is not).
binarynumber may have up to ten bits in two's complement representation; positive numbers are 0 to 111111111 (nine bits representing 0 to 511 decimal) and negative numbers 1111111111 to 1000000000 (ten bits representing -1 to -512 decimal)
numdigits is an optional number specifying the number of digits to return.
If binarynumber is negative, BIN2HEX returns ten hexadecimal digits, representing the hexadecimal number in twos complement form.

Example:

BIN2HEX("11101")

returns 1D as text.

BIN2HEX(11101)

returns 1D as text. The number 11101 has only 1 and 0 digits, and may be read as binary.

BIN2HEX("110100110"; 4)

returns 01A6 as text. BIN2HEX adds a leading zero to make 4 digits.

BIN2HEX("1111111110")

returns FFFFFFFFFE as text (twos complement representation of decimal -2).



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