Manuals/calci/DEC2HEX - Revision history

Swapna at 19:21, 17 April 2015

2015-04-17T19:21:17Z

Swapna at 02:48, 18 November 2013

2013-11-18T02:48:56Z

Swapna at 22:12, 17 November 2013

2013-11-17T22:12:12Z

Swapna at 22:10, 17 November 2013

2013-11-17T22:10:52Z

Swapna at 22:09, 17 November 2013

2013-11-17T22:09:07Z

Swapna at 22:05, 17 November 2013

2013-11-17T22:05:48Z

Swapna at 22:03, 16 November 2013

2013-11-16T22:03:48Z

Swapna at 21:57, 16 November 2013

2013-11-16T21:57:42Z

Swapna at 21:53, 16 November 2013

2013-11-16T21:53:23Z

MassBot1: Created page with "
'''DEC2HEX'''
2013-10-25T02:33:25Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''DEC2HEX'''</font></font><font face="Arial, san..."

New page
<div id="6SpaceContent" class="zcontent" align="left">

<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''DEC2HEX'''</font></font><font face="Arial, sans-serif"><font size="2">(</font></font><font face="Arial, sans-serif"><font size="2">'''num'''</font></font><font face="Arial, sans-serif"><font size="2">, p)</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">Where 'num' is the decimal integer to convert and 'p' is the number of characters to use. </font></font></font>

</div>
----
<div id="7SpaceContent" class="zcontent" align="left">

* <font color="#000000"><font face="Arial, sans-serif"><font size="2">DEC2HEX returns NAN(error) value, whenever the number is nonnumeric or negative. </font></font></font>
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">Places should be numeric and positive. Otherwise it shows the error values.</font></font></font>

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

DEC2HEX

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

<font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">DEC2HEX(num, p)</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=DEC2HEX(50, 5) is 32</nowiki></font></font></font>

<font color="#000000"><nowiki>=DEC2HEX(35) is 23</nowiki></font>

</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="5SpaceContent" class="zcontent" align="left">

<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''DEC2HEX'''</font></font><font face="Arial, sans-serif"><font size="2">(</font></font><font face="Arial, sans-serif"><font size="2">'''num'''</font></font><font face="Arial, sans-serif"><font size="2">, p)</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">Where 'num' is the decimal integer to convert and 'p' is the number of characters to use. </font></font></font>

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">

{| id="TABLE1" class="SpreadSheet blue"
|- class="even"
| class=" SelectTD SelectTD" |
<div id="1Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="1Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| Column1
| class=" " | Column2
| class=" " | Column3
| class=" " | Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 32
| class="sshl_f" | 23
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
| class=" " | Row2
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
| Row3
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
| Row4
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
| class=" " | Row5
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
| Row6
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

@@ Line 60: / Line 60: @@
 | class="sshl_f" | FFFFFFFE94
 |}
 == See Also ==

@@ Line 15: / Line 15: @@
 *'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'.
 For Example,

@@ Line 66: / Line 66: @@
 *[[Manuals/calci/DEC2OCT| DEC2OCT]]
-*[[Manuals/calci/BIN2DEC| BIN2DEC]]
+*[[Manuals/calci/HEX2DEC| HEX2DEC]]
 ==References==
 *[http://en.wikipedia.org/wiki/Hexadecimal Hexadecimal Numbers]

@@ Line 26: / Line 26: @@
 *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' to display the output, if the output is more than mentioned 'places'.
+*Calci ignores the 'places', if the output is more than mentioned 'places'.
-*Calci ignores the 'places' to display the output, if the 'places' is non-numeric or negative.
+*Calci ignores the 'places', if the 'places' is non-numeric or negative.
 *If 'places' is not an integer, Calci truncates the 'places' value.

@@ Line 19: / Line 19: @@
 DEC2HEX(50,5) ''returns 00032''
 DEC2HEX(4567890) ''returns 000045B352''
 DEC2HEX(35,3.3) ''returns 0023''
@@ Line 38: / Line 40: @@
 |- class="odd"
-| class="sshl_f" | DEC2HEX(10)
+| class="sshl_f" | DEC2HEX(512)
-| class="sshl_f" |
+| class="sshl_f" | 0000000200
 |- class="even"
-| class="sshl_f" | DEC2HEX(10,4)
+| class="sshl_f" | DEC2HEX(512,3)
-| class="sshl_f" |
+| class="sshl_f" | 200
 |- class="odd"
-| class="sshl_f" | DEC2HEX(100,8)
+| class="sshl_f" | DEC2HEX(2378,-4)
-| class="sshl_f" |
+| class="sshl_f" | 94A
 |- class="even"
-| class="sshl_f" | DEC2HEX(-56)
+| class="sshl_f" | DEC2HEX(7878.78)
-| class="sshl_f" |
+| class="sshl_f" | 0000001EC6
 |- class="odd"
-| class="sshl_f" | DEC2HEX(-512)
+| class="sshl_f" | DEC2HEX("-364")
-| class="sshl_f" |
+| class="sshl_f" | FFFFFFFE94
 |}

@@ Line 10: / Line 10: @@
 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.
 For Example,
-DEC2HEX(50, 5) ''returns 32''
+DEC2HEX(50,5) ''returns 00032''
-DEC2HEX(35) ''returns 23''
+*Calci displays an error message, if the 'number' is an invalid decimal number.
 == Examples ==

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+=DEC2HEX(number, places)=
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''DEC2HEX'''</font></font><font face="Arial, sans-serif"><font size="2">(</font></font><font face="Arial, sans-serif"><font size="2">'''num'''</font></font><font face="Arial, sans-serif"><font size="2">, p)</font></font></font>
+*Where 'number' is the decimal integer to be converted and
-<font color="#000000"><font face="Arial, sans-serif"><font size="2">Where 'num' is the decimal integer to convert and 'p' is the number of characters to use. </font></font></font>
+DEC2HEX() converts a decimal number to its hexadecimal equivalent.
-</div>
+*If the number is nonnumeric or negative, Calci returns an #ERROR value.
-----
+*If 'places' is non-numeric or negative, Calci returns an #ERROR value.
 </div>
@@ Line 16: / Line 13: @@
 <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
-DEC2HEX
 </div></div>