Manuals/calci/DEC2BIN - Revision history

Swapna at 17:45, 22 April 2015

2015-04-22T17:45:31Z

2015-04-17T19:18:29Z

2013-11-18T02:48:00Z

2013-11-18T02:40:49Z

2013-11-16T21:59:12Z

2013-11-16T17:43:04Z

2013-11-15T03:12:01Z

2013-11-14T22:08:17Z

2013-11-14T21:46:41Z

2013-11-14T21:46:07Z

@@ Line 58: / Line 58: @@
 | class="sshl_f" | DEC2BIN(-512)
 | class="sshl_f" | 1000000000
 |}

@@ Line 59: / Line 59: @@
 | class="sshl_f" | 1000000000
 |}
 == See Also ==

← Older revision		Revision as of 02:48, 18 November 2013
Line 20:		Line 20:

	*If 'places' is not an integer, Calci truncates the value and uses the integer part as input.		*If 'places' is not an integer, Calci truncates the value and uses the integer part as input.
		+
		+	*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,

@@ Line 17: / Line 17: @@
 *'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.
-<!--
+*If 'places' is negative, Calci ignores the places and displays a 10 bit binary output. Most significant bit is the sign bit and remaining are magnitude bits.
-*DEC2BIN returns #NUM! error, whenever the 'places' is nonnumeric, zero or negative.
--->
+*If 'places' is not an integer, Calci truncates the value and uses the integer part as input.
 For example,

@@ Line 35: / Line 35: @@
 {| id="TABLE1" class="SpreadSheet blue"
 |- class="even"
-| '''Function'''
+| class="  " | '''Function'''
 | class="  " | '''Binary Output'''

@@ Line 1: / Line 1: @@
-=DEC2BIN(number, padding)=
+=DEC2BIN(number, places)=
 *Where 'number' is the decimal integer to be converted and
-*'padding' is the number of characters to display the output.
+*'places' is the number of characters to display the output.
 DEC2BIN() function converts a decimal number to its binary equivalent.
@@ Line 9: / Line 9: @@
 == Description ==
-DEC2BIN(number, padding)
+DEC2BIN(number, places)
 *The 'number' should be in the range -512 to 511. If it exceeds the limit, Calci gives a #NUM! error.
@@ Line 15: / Line 15: @@
 *DEC2BIN returns an #ERROR, when the 'number' is nonnumeric.
-*'padding' argument is used to return the output with leading zeros. If 'padding' argument is not used, 'Calci' uses the minimum number of characters required to display the binary output.
+*'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.
 <!--
-*DEC2BIN returns #NUM! error, whenever the 'padding' is nonnumeric, zero or negative.
+*DEC2BIN returns #NUM! error, whenever the 'places' is nonnumeric, zero or negative.
 -->
-*If 'padding' contains decimal value, Calci truncates the decimal point and uses the integer value as input.
+*If 'places' contains decimal value, Calci truncates the decimal point and uses the integer value as input.
 For example,

← Older revision		Revision as of 22:08, 14 November 2013
Line 57:		Line 57:
	\| class="sshl_f" \| 1000000000		\| class="sshl_f" \| 1000000000
	\|}		\|}
		+
		+	== See Also ==
		+
		+	*[[Manuals/calci/DEC2HEX\| DEC2HEX]]
		+
		+	*[[Manuals/calci/DEC2OCT\| DEC2OCT]]
		+
		+	*[[Manuals/calci/BIN2DEC\| BIN2DEC]]
		+
		+	==References==
		+
		+	*[http://en.wikipedia.org/wiki/Decimal Decimal Numbers]

@@ Line 12: / Line 12: @@
 DEC2BIN(number, padding)
 *DEC2BIN returns the NAN(error) value, when the 'number' is negative or nonnumeric.
 *'padding' argument is used to return the output with leading zeros. If 'padding' argument is not used, 'Calci' uses the minimum number of characters required to display the binary output.
@@ Line 23: / Line 23: @@
 *If 'padding' contains decimal value, Calci truncates the decimal point and uses the integer value as input.
-Lets see an example,
+For example,
-DEC2BIN(10, 5) is 1010
+DEC2BIN(100) ''returns 0001100100''
-DEC2BIN(100) is 100100
+DEC2BIN(30,5.5) ''returns 011110''
 == Examples ==