Difference between revisions of "Manuals/calci/DEC2HEX"

From ZCubes Wiki
Jump to navigation Jump to search
 
(5 intermediate revisions by the same user not shown)
Line 10: Line 10:
 
DEC2HEX(number, places)
 
DEC2HEX(number, places)
  
*If the number is nonnumeric or negative, Calci returns an #ERROR value.
+
*The 'number' can be up to 20 digits (i.e. in-between -99999999999999999999 and -99999999999999999999).
*If 'places' is non-numeric or negative, Calci returns an #ERROR value.
+
*Output is a 40 bit number. The most significant bit is the sign bit and remaining bits are magnitude bits.
 +
*If 'number' is negative, Calci ignores the places and returns a 10 character (40 bit) hexadecimal number.
 +
*'places' argument can be omitted. Calci displays the hexadecimal output with minimum number of characters necessary.
 +
*'places' is used for padding the output with leading '0's'.
 +
*A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with octal numbers.
  
 
For Example,
 
For Example,
  
DEC2HEX(50, 5) ''returns 32''
+
DEC2HEX(50,5) ''returns 00032''
  
DEC2HEX(35) ''returns 23''
+
DEC2HEX(4567890) ''returns 000045B352''
 +
 
 +
DEC2HEX(35,3.3) ''returns 0023''
 +
 
 +
*Calci displays an error message, if the 'number' is an invalid decimal number.
 +
*If the 'number' is not an integer, Calci considers the integer part, and displays the output.
 +
*Calci ignores the 'places', if the output is more than mentioned 'places'.
 +
*Calci ignores the 'places', if the 'places' is non-numeric or negative.
 +
*If 'places' is not an integer, Calci truncates the 'places' value.
  
 
== Examples ==
 
== Examples ==
Line 29: Line 41:
  
 
|- class="odd"
 
|- class="odd"
| class="sshl_f" | DEC2HEX(10)
+
| class="sshl_f" | DEC2HEX(512)
| class="sshl_f" |  
+
| class="sshl_f" | 0000000200
  
 
|- class="even"
 
|- class="even"
| class="sshl_f" | DEC2HEX(10,4)
+
| class="sshl_f" | DEC2HEX(512,3)
| class="sshl_f" |  
+
| class="sshl_f" | 200
  
 
|- class="odd"
 
|- class="odd"
| class="sshl_f" | DEC2HEX(100,8)
+
| class="sshl_f" | DEC2HEX(2378,-4)
| class="sshl_f" |  
+
| class="sshl_f" | 94A
  
 
|- class="even"
 
|- class="even"
| class="sshl_f" | DEC2HEX(-56)
+
| class="sshl_f" | DEC2HEX(7878.78)
| class="sshl_f" |  
+
| class="sshl_f" | 0000001EC6
  
 
|- class="odd"
 
|- class="odd"
| class="sshl_f" | DEC2HEX(-512)
+
| class="sshl_f" | DEC2HEX("-364")
| class="sshl_f" |  
+
| class="sshl_f" | FFFFFFFE94
 
|}
 
|}
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|NFmDz1dQyPU|280|center|DEC2HEX}}
  
 
== See Also ==
 
== See Also ==
Line 55: Line 71:
 
*[[Manuals/calci/DEC2OCT| DEC2OCT]]
 
*[[Manuals/calci/DEC2OCT| DEC2OCT]]
  
*[[Manuals/calci/BIN2DEC| BIN2DEC]]
+
*[[Manuals/calci/HEX2DEC| HEX2DEC]]
  
 
==References==
 
==References==
  
 
*[http://en.wikipedia.org/wiki/Hexadecimal Hexadecimal Numbers]
 
*[http://en.wikipedia.org/wiki/Hexadecimal Hexadecimal Numbers]

Latest revision as of 13:21, 17 April 2015

DEC2HEX(number, places)

  • Where 'number' is the decimal integer to be converted and
  • 'places' is the number of characters to be used to display the output.

DEC2HEX() converts a decimal number to its hexadecimal equivalent.

Description

DEC2HEX(number, places)

  • The 'number' can be up to 20 digits (i.e. in-between -99999999999999999999 and -99999999999999999999).
  • Output is a 40 bit number. The most significant bit is the sign bit and remaining bits are magnitude bits.
  • If 'number' is negative, Calci ignores the places and returns a 10 character (40 bit) hexadecimal number.
  • 'places' argument can be omitted. Calci displays the hexadecimal output with minimum number of characters necessary.
  • 'places' is used for padding the output with leading '0's'.
  • A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with octal numbers.

For Example,

DEC2HEX(50,5) returns 00032

DEC2HEX(4567890) returns 000045B352

DEC2HEX(35,3.3) returns 0023

  • Calci displays an error message, if the 'number' is an invalid decimal number.
  • If the 'number' is not an integer, Calci considers the integer part, and displays the output.
  • Calci ignores the 'places', if the output is more than mentioned 'places'.
  • Calci ignores the 'places', if the 'places' is non-numeric or negative.
  • If 'places' is not an integer, Calci truncates the 'places' value.

Examples

Function HEX Output
DEC2HEX(512) 0000000200
DEC2HEX(512,3) 200
DEC2HEX(2378,-4) 94A
DEC2HEX(7878.78) 0000001EC6
DEC2HEX("-364") FFFFFFFE94

Related Videos

DEC2HEX

See Also

References