Manuals/calci/BIN2DEC - Revision history

Abin: /* Description */

2015-10-08T11:51:22Z

Description

Swapna at 17:56, 22 April 2015

2015-04-22T17:56:22Z

Swapna at 14:59, 11 December 2013

2013-12-11T14:59:22Z

Joseph: /* Examples */

2013-11-18T19:11:17Z

Examples

Swapna at 02:13, 18 November 2013

2013-11-18T02:13:22Z

Swapna at 02:12, 18 November 2013

2013-11-18T02:12:20Z

Swapna at 02:09, 18 November 2013

2013-11-18T02:09:55Z

Swapna at 02:07, 18 November 2013

2013-11-18T02:07:24Z

Swapna at 17:39, 16 November 2013

2013-11-16T17:39:46Z

Swapna at 02:54, 15 November 2013

2013-11-15T02:54:03Z

@@ Line 40: / Line 40: @@
 )SUM(BIN2DEC(100),BIN2DEC(101)) ''returns 9'' as a result.
-)AVERAGE(BIN2DEC(100) + BIN2DEC(101)) ''returns 4.5'' as a result.
+)AVERAGE(BIN2DEC(100) + BIN2DEC(101)) ''returns 9'' as a result.
 )BIN2DEC(110)+BIN2DEC(101)-BIN2DEC(100) ''returns 7'' as a result.
-−
 == Examples ==

@@ Line 1: / Line 1: @@
 =BIN2DEC(number,places)=
-<font color="red">places argument to be included in upcoming version</font>
+*Where 'number' is the binary number to be converted to decimal number.
-*Where 'number' is the binary number to be converted to decimal number.
+*'places' is the number of characters to display the output.
 BIN2DEC() converts a binary number to a decimal number.
@@ Line 9: / Line 9: @@
 == Description ==
-BIN2DEC(number)
+BIN2DEC(number,places)
-For example, BIN2DEC(101) ''returns 5'' as a result.
+For example, BIN2DEC(101,3) ''returns 005'' as a result.
               BIN2DEC(11110) ''returns 30'' as a result.
@@ Line 25: / Line 25: @@
 *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 -
@@ Line 54: / Line 58: @@
 |- class="even"
-| class="ssh1_f" | 11110
+| class="ssh1_f" | 11110,3
-| class="sshl_f" | 30
+| class="sshl_f" | 030
 |- class="odd"
 | class="ssh1_f" | 1010101010101010
-| class="sshl_f" | 42666
+| class="sshl_f" | 43690
 |- class="even"
 | class="ssh1_f" | 1111111111
-| class="sshl_f" | -1
+| class="sshl_f" | 1023
 |- class="odd"
 | class="ssh1_f" | 1111000000
-| class="sshl_f" | -64
+| class="sshl_f" | 960
 |- class="even"
 | class="ssh1_f" | 1000000000
-| class="sshl_f" | -512
+| class="sshl_f" | 512
 |}
-===ZOS Examples===
+==Related Videos==
-DEC2BIN(0..10)
+{{#ev:youtube|tfKe8PPI2zs|280|center|BIN2DEC}}
 == See Also ==

@@ Line 34: / Line 34: @@
 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(BIN2DEC(100),BIN2DEC(101)) ''returns 9'' as a result.
 )AVERAGE(BIN2DEC(100) + BIN2DEC(101)) ''returns 4.5'' as a result.

← Older revision		Revision as of 19:11, 18 November 2013
Line 73:		Line 73:
	\| class="sshl_f" \| -512		\| class="sshl_f" \| -512

		+	\|}
		+
		+	===ZOS Examples===
		+	DEC2BIN(0..10)
		+
		+	{\| class="wikitable"
		+	\|-
		+	! number !! DEC2BIN
		+	\|-
		+	\| 0 \|\| 0000000000
		+	\|-
		+	\| 1 \|\| 0000000001
		+	\|-
		+	\| 2 \|\| 0000000010
		+	\|-
		+	\| 3 \|\| 0000000011
		+	\|-
		+	\| 4 \|\| 0000000100
		+	\|-
		+	\| 5 \|\| 0000000101
		+	\|-
		+	\| 6 \|\| 0000000110
		+	\|-
		+	\| 7 \|\| 0000000111
		+	\|-
		+	\| 8 \|\| 0000001000
		+	\|-
		+	\| 9 \|\| 0000001001
		+	\|-
		+	\| 10 \|\| 0000001010
	\|}		\|}

@@ Line 46: / Line 46: @@
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class="  " | ''Binary Input''
+| class="  " | '''Binary Input'''
-| class="  " | ''Decimal Output''
+| class="  " | '''Decimal Output'''
 |- class="odd"

@@ Line 32: / Line 32: @@
 *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)) that displays the result as ''9''.

@@ Line 5: / Line 5: @@
 *Where 'number' is the binary number to be converted to decimal number.
-*BIN2DEC() converts a binary number to a decimal number.
+BIN2DEC() converts a binary number to a decimal number.
 == Description ==
@@ Line 17: / Line 17: @@
 *This function is used to convert a binary number to a decimal number.
-*Binaray number is represented using digits 1 or 0 only. The number can also be entered in text format (e.g "101").
+*Binary number 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.

@@ Line 1: / Line 1: @@
-=BIN2DEC(number,padding)=
+=BIN2DEC(number,places)=
-<font color="red">padding argument to be included in upcoming version</font>
+<font color="red">places argument to be included in upcoming version</font>
 *Where 'number' is the binary number to be converted to decimal number.
@@ Line 83: / Line 83: @@
 *[[Manuals/calci/DEC2BIN| DEC2BIN]]
-*[[Manuals/calci/OCT2BIN | OCT2BIN]]
+*[[Manuals/calci/OCT2BIN| OCT2BIN]]
 ==References==
 *[http://en.wikipedia.org/wiki/Binary_number#Conversion_to_and_from_other_numeral_systems Conversion of Binary Numbers]

← Older revision		Revision as of 02:54, 15 November 2013
Line 1:		Line 1:
−	=BIN2DEC(number)=	+	=BIN2DEC(number,padding)=
		+
		+	<font color="red">padding argument to be included in upcoming version</font>

	*Where 'number' is the binary number to be converted to decimal number.		*Where 'number' is the binary number to be converted to decimal number.