Manuals/calci/HEX2DEC - Revision history

Swapna at 19:10, 22 April 2015

2015-04-22T19:10:01Z

Swapna at 18:22, 13 December 2013

2013-12-13T18:22:25Z

Swapna at 14:56, 11 December 2013

2013-12-11T14:56:46Z

Swapna at 21:53, 4 December 2013

2013-12-04T21:53:59Z

Swapna at 21:42, 4 December 2013

2013-12-04T21:42:06Z

Swapna at 21:11, 4 December 2013

2013-12-04T21:11:15Z

MassBot1: Created page with "
'''HEX2DEC'''
2013-10-25T02:36:48Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''HEX2DEC'''</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">'''HEX2DEC'''</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">)</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">Where 'num' is the hexadecimal number.</font></font></font>

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

<font color="#000000"><font face="Arial, sans-serif"><font size="2">This function ronverts a hexadecimal number to decimal.</font></font></font>

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

HEX2DEC

</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">HEX2DEC(num)</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=HEX2DEC("55") is 85</nowiki></font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=HEX2DEC("3DA408B") is 64635019</nowiki></font></font></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="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="2SpaceContent" class="zcontent" align="left">

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

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

@@ Line 1: / Line 1: @@
 =HEX2DEC(number, places)=
-<font color="red">places argument to be included in upcoming version</font>
+*Where <math>number</math> is the hexadecimal number to be converted to decimal number.
-*Where <math>number</math> is the hexadecimal number to be converted to decimal number.
+*<math>places</math> is the number of characters to display the output.
 HEX2DEC() converts a hexadecimal number to a decimal number.
@@ Line 9: / Line 9: @@
 == Description ==
-HEX2DEC(number)
+HEX2DEC(number, places)
 For example,
@@ Line 15: / Line 15: @@
 HEX2DEC("F") ''returns 15'' as a result.
-HEX2DEC("01D") ''returns 29'' as a result.
+HEX2DEC("01D",3) ''returns 029'' as a result.
 *This function is used to convert a hexadecimal number to a decimal number.
@@ Line 22: / Line 22: @@
 *A <math>number</math> can be up to 10 characters (40 bits). The most significant bit is the sign bit and remaining are magnitude bits. A negative number is represented in 2's complement format.
 *If the <math>number</math> is not a valid number, 'Calci' returns an #ERROR message.
 Below are few examples that show the use of combination of functions and get the result in decimal -
@@ Line 43: / Line 46: @@
 |- class="even"
-| class="ssh1_f" | 110
+| class="ssh1_f" | 110,3.5
-| class="sshl_f" | 272
+| class="sshl_f" | 0272
 |- class="odd"
@@ Line 52: / Line 55: @@
 |- class="even"
 | class="ssh1_f" | FFFFFFFFFF
-| class="sshl_f" | -1
+| class="sshl_f" | 109951162775
 |}
 == See Also ==

@@ Line 3: / Line 3: @@
 <font color="red">places argument to be included in upcoming version</font>
-*Where 'number' is the hexadecimal number to be converted to decimal number.
+*Where <math>number</math> is the hexadecimal number to be converted to decimal number.
 HEX2DEC() converts a hexadecimal number to a decimal number.
@@ Line 19: / Line 19: @@
 *This function is used to convert a hexadecimal number to a decimal number.
 *Hexadecimal number uses digits from 0 to 9 and characters from A to F. The number can also be entered in text format (e.g "1F").
-*A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers.
+*A <math>number</math> preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers.
-*A number can be up to 10 characters (40 bits). The most significant bit is the sign bit and remaining are magnitude bits. A negative number is represented in 2's complement format.
+*A <math>number</math> can be up to 10 characters (40 bits). The most significant bit is the sign bit and remaining are magnitude bits. A negative number is represented in 2's complement format.
-*If the number is not a valid number, 'Calci' returns an #ERROR message.
+*If the <math>number</math> is not a valid number, 'Calci' returns an #ERROR message.
 Below are few examples that show the use of combination of functions and get the result in decimal -

@@ Line 25: / Line 25: @@
 Below are few examples that show the use of combination of functions and get the result in decimal -
-)SUM(HEX2DEC("FF") + HEX2DEC("57")) ''returns 342'' as a result.
+)SUM(HEX2DEC("FF"),HEX2DEC("57")) ''returns 342'' as a result.
 )HEX2DEC("65") - HEX2DEC("42") ''returns 35'' as a result.

@@ Line 11: / Line 11: @@
 HEX2DEC(number)
-For example, HEX2DEC("F") ''returns 15'' as a result.
+For example,
-             HEX2DEC("01D") ''returns 29'' as a result.
+HEX2DEC("F") ''returns 15'' as a result.
 *This function is used to convert a hexadecimal number to a decimal number.
 *Hexadecimal number uses digits from 0 to 9 and characters from A to F. The number can also be entered in text format (e.g "1F").
 *A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers.
-*A number can be up to 10 characters (40 bits). The most significant bit is the sign bit and remaining are magnitude bits.
+*A number can be up to 10 characters (40 bits). The most significant bit is the sign bit and remaining are magnitude bits. A negative number is represented in 2's complement format.
 *If the number is not a valid number, 'Calci' returns an #ERROR message.
@@ Line 25: / Line 27: @@
 )SUM(HEX2DEC("FF") + HEX2DEC("57")) ''returns 342'' as a result.
-)HEX2DEC("65")- HEX2DEC("42") ''returns 35'' as a result.
+)HEX2DEC("65") - HEX2DEC("42") ''returns 35'' as a result.
 == Examples ==
@@ Line 52: / Line 54: @@
 | class="sshl_f" | -1
 |}

@@ Line 11: / Line 11: @@
 HEX2DEC(number)
-For example, HEX2DEC() ''returns 5'' as a result.
+For example, HEX2DEC("F") ''returns 15'' as a result.
-              HEX2DEC() ''returns 30'' as a result.
+              HEX2DEC("01D") ''returns 29'' as a result.
 *This function is used to convert a hexadecimal number to a decimal number.
-*Hexadecimal number uses digits from 0 to 9 and characters from A to F.is represented using digits 1 or 0 only. The number can also be entered in text format (e.g "101").
+*Hexadecimal number uses digits from 0 to 9 and characters from A to F. The number can also be entered in text format (e.g "1F").
-*The conversion can be obtained for a binary number upto 17 bits for positive numbers and 10 bits for negative numbers.
+*A number preceding with '0' (e.g 013) should be written in text format ("013") to avoid confusion with octal numbers.
-*The most significant bit represents the 'sign' of the number (0=positive, 1=negative). Negative numbers are represented using 2's complement notation.
+*A number can be up to 10 characters (40 bits). The most significant bit is the sign bit and remaining are magnitude bits.
 *If the number is not a valid number, 'Calci' returns an #ERROR message.
 Below are few examples that show the use of combination of functions and get the result in decimal -
-)SUM(BIN2DEC(100) + BIN2DEC(101)) ''returns 9'' as a result.
+)SUM(HEX2DEC("FF") + HEX2DEC("57")) ''returns 342'' as a result.
-HEX2DEC
+)HEX2DEC("65")- HEX2DEC("42") ''returns 35'' as a result.
-</div></div>
+== Examples ==
 <div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class=" " |
+| class="  " | '''HEX Input'''
-| Column1
+| class="  " | '''Decimal Output'''
-| class="  " | Column2
 |- class="odd"
 | class="sshl_f" | 85
-| class="sshl_f" |
+| class="sshl_f" | 133
-−
 |- class="even"
-| class="  " | Row2
+| class="ssh1_f" | 110
-| class="sshl_f" | 64635019
+| class="sshl_f" | 272
-| class="SelectTD SelectTD " |
 |- class="odd"
-| Row3
+| class="ssh1_f" | FFAFFAFFA
-| class="                                       sshl_f      " |
+| class="sshl_f" | 68635570170
-−
 |- class="even"
-| Row6
+| class="ssh1_f" | FFFFFFFFFF
+| class="sshl_f" | -1
 |}

← Older revision		Revision as of 21:11, 4 December 2013
Line 1:		Line 1:
		+	=HEX2DEC(number, places)=
		+
		+	<font color="red">places argument to be included in upcoming version</font>
		+
		+	*Where 'number' is the hexadecimal number to be converted to decimal number.
		+
		+	HEX2DEC() converts a hexadecimal number to a decimal number.
		+
		+	== Description ==
		+
		+	HEX2DEC(number)
		+
		+	For example, HEX2DEC() ''returns 5'' as a result.
		+
		+	HEX2DEC() ''returns 30'' as a result.
		+
		+	*This function is used to convert a hexadecimal number to a decimal number.
		+	*Hexadecimal number uses digits from 0 to 9 and characters from A to F.is represented using digits 1 or 0 only. The number can also be entered in text format (e.g "101").
		+	*The conversion can be obtained for a binary number upto 17 bits for positive numbers and 10 bits for negative numbers.
		+	*The most significant bit represents the 'sign' of the number (0=positive, 1=negative). Negative numbers are represented using 2's complement notation.
		+
		+	*Positive numbers may be from 0 (000000000) to 130046 (11111111111111110) and negative numbers from -1 (1111111111) to -512 (1000000000).
		+
		+	*A number preceding with '0' (e.g 01111111111) should be written in text format ("01111111111") to avoid confusion with octal numbers.
		+
		+	*A binary number (e.g '101') is converted to decimal number (base 2) as -
		+	(12^2)+(02^1)+(1*2^0)=4+0+1= ''5''
		+
		+	*If the number is not a valid number, 'Calci' returns an #ERROR message.
		+
		+	Below are few examples that show the use of combination of functions and get the result in decimal -
		+
		+	1)SUM(BIN2DEC(100) + BIN2DEC(101)) ''returns 9'' as a result.
		+
		+	2)AVERAGE(BIN2DEC(100) + BIN2DEC(101)) ''returns 4.5'' as a result.
		+
		+	3)BIN2DEC(110)+BIN2DEC(101)-BIN2DEC(100) ''returns 7'' as a result.
		+
		+
		+
		+
		+
		+
	<div id="6SpaceContent" class="zcontent" align="left">		<div id="6SpaceContent" class="zcontent" align="left">