Manuals/calci/PRODUCT - Revision history

Devika at 21:13, 21 August 2018

2018-08-21T21:13:52Z

Devika at 20:29, 28 June 2018

2018-06-28T20:29:11Z

Jayaram at 11:17, 13 March 2017

2017-03-13T11:17:23Z

Swapna at 20:58, 17 April 2015

2015-04-17T20:58:27Z

Swapna at 21:54, 13 December 2013

2013-12-13T21:54:00Z

Swapna: /* Examples */

2013-12-08T00:05:47Z

Examples

Swapna at 23:57, 7 December 2013

2013-12-07T23:57:34Z

Swapna at 23:04, 7 December 2013

2013-12-07T23:04:10Z

Swapna at 22:56, 7 December 2013

2013-12-07T22:56:27Z

Swapna at 22:31, 7 December 2013

2013-12-07T22:31:16Z

@@ Line 2: / Line 2: @@
 *Parameter are any integer values.
+**PRODUCT(), Multiplies its arguments.
 == Description ==

@@ Line 1: / Line 1: @@
-=PRODUCT(n1,n2,n3...)=
+<div style="font-size:30px">'''PRODUCT()'''</div><br/>
-*where <math>n1,n2,n3...</math> are integer values.
+*Parameter are any integer values.
-PRODUCT() multiplies the given arguments and displays the product.
+PRODUCT(), Multiplies its arguments.
 == Description ==
-PRODUCT(n1,n2,n3...)
+PRODUCT()
 For Example,
@@ Line 15: / Line 15: @@
 PRODUCT(0.1,5,-3) ''returns -1.5''.
-*Number arguments <math>n1,n2,n3...</math> can be positive or negative.
+*Number arguments can be positive or negative.
 *Function should contain at least one number (i.e. <math>n1</math>) or range, else Calci displays an error message. There can be any number of arguments.
 *If logical values, empty cells or text are entered directly as a part of argument, they are ignored.

← Older revision		Revision as of 11:17, 13 March 2017
Line 70:		Line 70:
	==References==		==References==
	*[http://en.wikipedia.org/wiki/Product_(mathematics) PRODUCT]		*[http://en.wikipedia.org/wiki/Product_(mathematics) PRODUCT]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 58: / Line 58: @@
   =PRODUCT(B1:B3) : Calculates the product of values in the range B1 to B3. Empty cell is ignored. Returns ''-20'' as a result.
   =PRODUCT(B4,2)  : Calculates the product of reference B4 and 2. Text is ignored. Returns ''2'' as a result.
 ==See also==

@@ Line 1: / Line 1: @@
 =PRODUCT(n1,n2,n3...)=
-*where n1,n2,n3... are integer values.
+*where <math>n1,n2,n3...</math> are integer values.
 PRODUCT() multiplies the given arguments and displays the product.
@@ Line 15: / Line 15: @@
 PRODUCT(0.1,5,-3) ''returns -1.5''.
-*Number arguments can be positive or negative.
+*Number arguments <math>n1,n2,n3...</math> can be positive or negative.
-*Function should contain at least one number (i.e n1) or range, else Calci displays an error message. There can be any number of arguments.
+*Function should contain at least one number (i.e. <math>n1</math>) or range, else Calci displays an error message. There can be any number of arguments.
 *If logical values, empty cells or text are entered directly as a part of argument, they are ignored.
 *If arguments is an array or reference, numbers and logical values are considered. Empty cells and text are ignored.

@@ Line 49: / Line 49: @@
 |- class="even"
-| class="sshl_f" | TRUE
+| class="sshl_f" | FALSE
 | class="sshl_f" |
 | class="sshl_f" |
@@ Line 58: / Line 58: @@
   =PRODUCT(B1:B3) : Calculates the product of values in the range B1 to B3. Empty cell is ignored. Returns ''-20'' as a result.
   =PRODUCT(B4,2)  : Calculates the product of reference B4 and 2. Text is ignored. Returns ''2'' as a result.

@@ Line 13: / Line 13: @@
 PRODUCT(34,99) ''returns 3366''.
-PRODUCT(0.1,5,-3) ''returns -1.6''.
+PRODUCT(0.1,5,-3) ''returns -1.5''.
 *Number arguments can be positive or negative.
 *Function should contain at least one number (i.e n1) or range, else Calci displays an error message. There can be any number of arguments.
-*If arguments is an array or reference, only numbers are considered.
+*If logical values, empty cells or text are entered directly as a part of argument, they are ignored.
-*The arguments are ignored, if
+*If arguments is an array or reference, numbers and logical values are considered. Empty cells and text are ignored.
-# It is logical values,
+*Logical values are evaluated as TRUE=1, FALSE=0.
 *PRODUCT() can also be used for an array of numbers as -
   PRODUCT(1..10) ''returns 3628800''.
@@ Line 31: / Line 29: @@
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class="sshl_f" | 4
+| class="sshl_f" | 0.44
-| class="sshl_f" |
+| class="sshl_f" | -5
 | class="sshl_f" |
 |- class="odd"
-| class="sshl_f " | 10
+| class="sshl_f" | 10
 | class="sshl_f" | 4
 | class="sshl_f" |
@@ Line 46: / Line 44: @@
 |- class="odd"
-| class="sshl_f " | 20
+| class="sshl_f" | 20
-| class="sshl_f" |
+| class="sshl_f" | TEXT
 | class="sshl_f" |
 |- class="even"
-| class="sshl_f" | 2600
+| class="sshl_f" | TRUE
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="even"
+ =PRODUCT(A1:A4) : Calculates the product of values in the range A1 to A4. Returns ''1144'' as a result.
-| class="sshl_f" |
+ =PRODUCT(10,A5) : Calculates the product of 10 and reference A5 (value 0 for FALSE). Returns ''0'' as a result.
-| class="sshl_f" |
+ =PRODUCT(B1:B3) : Calculates the product of values in the range B1 to B3. Empty cell is ignored. Returns ''-20'' as a result.
-| class="sshl_f" |
+ =PRODUCT(B4,2)  : Calculates the product of reference B4 and 2. Text is ignored. Returns ''2'' as a result.

@@ Line 11: / Line 11: @@
 For Example,
-PRODUCT(34,99) ''returns ''.
+PRODUCT(34,99) ''returns 3366''.
-PRODUCT(0.02,5,-3) ''returns ''.
+PRODUCT(0.1,5,-3) ''returns -1.6''.
 *Arguments can be numbers, logical values, text representations.
 *Function should contain at least one argument, else Calci displays an error message. There can be any number of arguments.
 *If arguments is an array or reference, only numbers are considered.
 *The arguments are ignored, if
-)It is logical values,
+# It is logical values,
-)It is empty cells,
+# It is empty cells,
-)It is text.
+# It is text.
 *PRODUCT() can also be used for an array of numbers as -
-  PRODUCT(1..10) ''returns ''.
+  PRODUCT(1..10) ''returns 3628800''.
 == Examples ==