Manuals/calci/DPRODUCT - Revision history

Swapna: /* Examples */

2015-10-10T19:27:32Z

Examples

Swapna: /* Examples */

2015-10-10T19:26:51Z

Examples

Swapna at 20:34, 17 April 2015

2015-04-17T20:34:08Z

Swapna at 21:02, 24 November 2013

2013-11-24T21:02:03Z

Swapna: /* Description */

2013-11-23T22:07:32Z

Description

Swapna at 22:05, 23 November 2013

2013-11-23T22:05:24Z

Swapna: /* Description */

2013-11-22T22:35:58Z

Description

Swapna at 22:35, 22 November 2013

2013-11-22T22:35:30Z

Swapna: /* Examples */

2013-11-22T22:35:00Z

Examples

Swapna: /* Examples */

2013-11-22T22:34:07Z

Examples

@@ Line 85: / Line 85: @@
-= DPRODUCT(A3:D7,"Profit",A1:B2)  : Calculates the product of percentage profits of Pens in the range A3 to D7, for the cells with Quantity>10. <br>Returns '''8''' as a result.
+= DPRODUCT(A3:D7,"Profit",A1:B2)  : Calculates the product of percentage profits of Pens in the range A3 to D7, for the cells with Quantity>10. Returns '''8''' as a result.
-= DPRODUCT(A3:D7,4,A3:D7)  : Calculates the product in the range A3 to D7, of all values in Profit column. <br>Returns '''40''' as a result.
+= DPRODUCT(A3:D7,4,A3:D7)  : Calculates the product in the range A3 to D7, of all values in Profit column. Returns '''40''' as a result.
 ==Related Videos==

@@ Line 21: / Line 21: @@
 == Examples ==
-Consider the following table with Stationary Items, Quantity, Price and Percentage Profit.
+Consider the following table in Zcalci with Stationary Items, Quantity, Price and Percentage Profit.
 <div id="4SpaceContent" class="zcontent" align="left">
@@ Line 27: / Line 27: @@
 {| id="TABLE2" class="SpreadSheet blue"
 |- class="even"
 | class="sshl_f" | '''Item'''
 | class="sshl_f" | '''Quantity'''
@@ Line 32: / Line 40: @@
 | class="sshl_f" | '''Profit'''
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Pen
 | class="sshl_f" | &gt;10
@@ Line 38: / Line 47: @@
 | class="ssh1_f" |
-|- class="even"
 | class="sshl_f" | '''Item'''
 | class="sshl_f" | '''Quantity'''
@@ Line 44: / Line 55: @@
 | class="sshl_f" | '''Profit'''
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Pen
 | class="sshl_f" | 12
@@ Line 50: / Line 62: @@
 | class="sshl_f" | 2
-|- class="even"
+|- class="odd"
 | class="sshl_f" | Pencil
 | class="sshl_f" | 20
@@ Line 56: / Line 69: @@
 | class="sshl_f" | 1
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Books
 | class="sshl_f" | 25
@@ Line 62: / Line 76: @@
 | class="ssh1_f" | 5
-|- class="even"
+|- class="odd"
 | class="sshl_f" | Pen
 | class="sshl_f" | 30
@@ Line 70: / Line 85: @@
-= DPRODUCT(A3:D7,"Profit",A1:B2)  : Calculates the product of percentage profits of Pens in the range A3 to D7, for the cells with Quantity>10. ''Returns 8'' as a result.
+= DPRODUCT(A3:D7,"Profit",A1:B2)  : Calculates the product of percentage profits of Pens in the range A3 to D7, for the cells with Quantity>10. <br>Returns '''8''' as a result.
-= DPRODUCT(A3:D7,4,A3:D7)  : Calculates the product in the range A3 to D7, of all values in Profit column. ''Returns 40'' as a result.
+= DPRODUCT(A3:D7,4,A3:D7)  : Calculates the product in the range A3 to D7, of all values in Profit column. <br>Returns '''40''' as a result.
 ==Related Videos==

← Older revision		Revision as of 20:34, 17 April 2015
Line 73:		Line 73:

	= DPRODUCT(A3:D7,4,A3:D7) : Calculates the product in the range A3 to D7, of all values in Profit column. ''Returns 40'' as a result.		= DPRODUCT(A3:D7,4,A3:D7) : Calculates the product in the range A3 to D7, of all values in Profit column. ''Returns 40'' as a result.
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|loDtcf7Z0xs\|280\|center\|DPRODUCT}}

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

@@ Line 18: / Line 18: @@
 *'criteria' can be any range on the Calci with minimum of one column and at least one row indicating the condition.
 *'criteria' columns should not overlap the list of data.
 == Examples ==

@@ Line 15: / Line 15: @@
 This function returns the product of values from the database that satisfy a given condition.
-*A 'field' argument can be expressed as "Salary" (a column name) or 3(position of the column).
+*A 'field' argument can be expressed as "Price" (a column name) or 3(position of the column).
 *'criteria' can be any range on the Calci with minimum of one column and at least one row indicating the condition.
 *'criteria' columns should not overlap the list of data.
@@ Line 22: / Line 22: @@
 DPRODUCT(A3:D7,"Profit",A3:D7) ''returns 40'' as a result.
 == Examples ==

@@ Line 13: / Line 13: @@
 DPRODUCT(database, field, criteria)
-This function returns the product of values from the database that satisfy the given condition.
+This function returns the product of values from the database that satisfy a given condition.
 *A 'field' argument can be expressed as "Salary" (a column name) or 3(position of the column).

← Older revision		Revision as of 22:35, 22 November 2013
Line 19:		Line 19:
	*'criteria' columns should not overlap the list of data.		*'criteria' columns should not overlap the list of data.

		+	== Examples ==

−	~~== Examples ==~~
	Consider the following table with Employee names, Age and Salary columns.		Consider the following table with Employee names, Age and Salary columns.

← Older revision		Revision as of 22:34, 22 November 2013
Line 20:		Line 20:

	== Examples ==		== Examples ==
		+	Consider the following table with Employee names, Age and Salary columns.
		+
		+	Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.
		+
	<div id="2SpaceContent" class="zcontent" align="left">		<div id="2SpaceContent" class="zcontent" align="left">