Manuals/calci/HEX2BIN - Revision history

Swapna at 20:47, 17 April 2015

2015-04-17T20:47:40Z

Swapna at 18:20, 13 December 2013

2013-12-13T18:20:00Z

Swapna: 2

2013-12-04T12:18:47Z

Swapna: /* Examples */

2013-12-04T02:25:32Z

Examples

Swapna: /* References */

2013-12-04T02:16:06Z

References

Swapna at 02:11, 4 December 2013

2013-12-04T02:11:22Z

Swapna: /* Examples */

2013-12-04T02:08:13Z

Examples

Swapna at 01:51, 4 December 2013

2013-12-04T01:51:58Z

Swapna at 01:47, 4 December 2013

2013-12-04T01:47:52Z

Swapna at 01:08, 4 December 2013

2013-12-04T01:08:08Z

← Older revision		Revision as of 20:47, 17 April 2015
Line 58:		Line 58:

	\|}		\|}
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|7yfNWmHR0GE\|280\|center\|HEX2BIN}}

	== See Also ==		== See Also ==

@@ Line 1: / Line 1: @@
 =HEX2BIN(number, places)=
-*Where 'number' is the hexadecimal number to be converted, and
+*Where <math>number</math> is the hexadecimal number to be converted, and
-*'places' is the number of characters to display the output.
+*<math>places</math> is the number of characters to display the output.
 HEX2BIN() converts a hexadecimal number to its binary equivalent.
@@ Line 15: / Line 15: @@
 HEX2BIN("4F",4) ''returns 1001111''
-*The 'number' can be maximum of 10 characters (40 bits). If it exceeds the limit, Calci gives a #NUM! error.
+*The <math>number</math> can be maximum of 10 characters (40 bits). If it exceeds the limit, Calci gives a #NUM! error.
 *Hexadecimal number uses numbers from 0 to 9 and characters from A to F. Hence, the number argument should be entered in quotes (e.g. "1FF").
 *The most significant bit of the number is the sign bit and remaining bits are magnitude bits. A negative number is represented in 2's complement form.
-*Calci returns an #ERROR message, if the 'number' is not a valid hexadecimal number.
+*Calci returns an #ERROR message, if the <math>number</math> is not a valid hexadecimal number.
-*'places' argument is used to return the output with leading zeros. If 'places' argument is not used, 'Calci' uses the minimum number of characters required to display the binary output.
+*<math>places</math> argument is used to return the output with leading zeros. If <math>places</math> argument is not used, 'Calci' uses the minimum number of characters required to display the binary output.
-*If 'places' is negative, Calci ignores the places and uses the minimum number of characters required to display the binary output.
+*If <math>places</math> is negative, Calci ignores the places and uses the minimum number of characters required to display the binary output.
-*If 'places' is not an integer, Calci rounds the value and uses the integer part as input.
+*If <math>places</math> is not an integer, Calci rounds the value and uses the integer part as input.
-*If 'places' is less than the number of output characters, Calci ignores the places and uses the minimum number of characters required to display the output.
+*If <math>places</math> is less than the number of output characters, Calci ignores the places and uses the minimum number of characters required to display the output.
 == Examples ==

@@ Line 61: / Line 61: @@
 == See Also ==
-*[[Manuals/calci/DEC2HEX| DEC2HEX]]
+*[[Manuals/calci/HEX2DEC| HEX2DEC]]
-*[[Manuals/calci/DEC2OCT| DEC2OCT]]
+*[[Manuals/calci/HEX2OCT| HEX2OCT]]
-*[[Manuals/calci/BIN2DEC| BIN2DEC]]
+*[[Manuals/calci/BIN2HEX| BIN2HEX]]
 ==References==
 *[http://en.wikipedia.org/wiki/Hexadecimal#Conversion Hexadecimal to Binary Conversion]

@@ Line 52: / Line 52: @@
 | class="sshl_f" | HEX2BIN("DF")
 | class="sshl_f" | 0011011111
 |}

← Older revision		Revision as of 02:16, 4 December 2013
Line 64:		Line 64:
	==References==		==References==

−	*[http://en.wikipedia.org/wiki/~~Decimal Decimal Numbers~~]	+	*[http://en.wikipedia.org/wiki/Hexadecimal#Conversion Hexadecimal to Binary Conversion]

@@ Line 38: / Line 38: @@
 |- class="even"
 | class="sshl_f" | HEX2BIN("10",8)
-| class="sshl_f" |
+| class="sshl_f" | 00010000
 |- class="odd"
-| class="sshl_f" | HEX2BIN("FFFFF00",7)
+| class="sshl_f" | HEX2BIN("FFFFFFFE00")
-| class="sshl_f" |
+| class="sshl_f" | 1000000000
 |- class="even"
-| class="sshl_f" | HEX2BIN("FF0FF0",-5)
+| class="sshl_f" | HEX2BIN("0FF",-5)
-| class="sshl_f" |
+| class="sshl_f" | 11111111
 |- class="odd"
-| class="sshl_f" | HEX2BIN()
+| class="sshl_f" | HEX2BIN("DF")
-| class="sshl_f" |
+| class="sshl_f" | 0011011111
 |}

@@ Line 13: / Line 13: @@
 HEX2BIN("1EE",9) ''returns 111101110 ''
-HEX2BIN("4F,4) ''returns 1001111''
+HEX2BIN("4F",4) ''returns 1001111''
 *The 'number' can be maximum of 10 characters (40 bits). If it exceeds the limit, Calci gives a #NUM! error.
@@ Line 23: / Line 23: @@
 *If 'places' is not an integer, Calci rounds the value and uses the integer part as input.
-HEX2BIN() ''returns 011110''
+{| id="TABLE1" class="SpreadSheet blue"
-*If SomeNumber and NumberPlaces are non-numeric, HEX2BIN returns the#ERROR.
+|- class="even"
-*If the NumberPlaces is a negative, it returns the #ERROR.
+| class="sshl_f" | HEX2BIN("10",8)
-*If NumberPlaces &gt; LengthofSomeNumber then  returns #ERROR.
+| class="sshl_f" |
-</div>
+|- class="odd"
-----
+| class="sshl_f" | HEX2BIN("FFFFF00",7)
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+| class="sshl_f" |
-HEX2BIN
+|- class="even"
-<font size="6"></font>
+|- class="odd"
-</div></div>
+== See Also ==
-Lets see an example in (Column1, Row1)
+*[[Manuals/calci/DEC2HEX| DEC2HEX]]
-<nowiki>=HEX2BIN("A",5)</nowiki>
+*[[Manuals/calci/DEC2OCT| DEC2OCT]]
-HEX2BIN converts A to 01010.
+*[[Manuals/calci/BIN2DEC| BIN2DEC]]
-Consider an another example(Column1,Row2)
+==References==
-<div align="left">[[Image:calci1.gif]]</div></div>
+*[http://en.wikipedia.org/wiki/Decimal Decimal Numbers]