Manuals/calci/DMIN - Revision history

Devika at 19:48, 24 August 2018

2018-08-24T19:48:13Z

Devika at 22:43, 3 August 2018

2018-08-03T22:43:31Z

Devika at 22:42, 3 August 2018

2018-08-03T22:42:19Z

Jayaram at 11:25, 14 March 2017

2017-03-14T11:25:14Z

Swapna: /* Examples */

2015-10-10T02:07:49Z

Examples

Swapna: /* Examples */

2015-10-10T02:06:34Z

Examples

Swapna at 22:55, 9 October 2015

2015-10-09T22:55:53Z

Swapna at 20:31, 17 April 2015

2015-04-17T20:31:37Z

Swapna: /* Examples */

2013-11-24T21:08:14Z

Examples

Swapna: /* Examples */

2013-11-24T21:07:11Z

Examples

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''DMIN (Array,Field,Criteria)'''</div><br/>
 *Where 'Array' is the range of cells that makes up the list or database
 *'Field' shows which column is used in the function and
 *'Criteria' is the range of cells that contains the specified condition.
 **DMIN(), returns the minimum value from selected database entries.

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''DMIN (Array,Field,Criteria)'''</div><br/>
@@ Line 8: / Line 7: @@
 *'Criteria' is the range of cells that contains the specified condition.
-DMIN() displays the smallest number in a column of a list or database that matches the specified criteria.
+**DMIN(), returns the minimum value from selected database entries.
 == Description ==

@@ Line 1: / Line 1: @@
 = DMIN(database, field, criteria)=
-*Where 'database' is the range of cells that makes up the list or database
+*Where 'Array' is the range of cells that makes up the list or database
-*'field' shows which column is used in the function and
+*'Field' shows which column is used in the function and
-*'criteria' is the range of cells that contains the specified condition.
+*'Criteria' is the range of cells that contains the specified condition.
 DMIN() displays the smallest number in a column of a list or database that matches the specified criteria.
@@ Line 11: / Line 12: @@
 == Description ==
-DMIN(database, field, criteria)
+DMIN (Array,Field,Criteria)
 This function returns the smallest number from the database that satisfies the 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 "Salary" (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.
 *The Criteria columns should not overlap the list of data.

← Older revision		Revision as of 11:25, 14 March 2017
Line 115:		Line 115:
	*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions]		*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions]
	*[http://en.wikipedia.org/wiki/Aggregate_function DMIN]		*[http://en.wikipedia.org/wiki/Aggregate_function DMIN]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 101: / Line 101: @@
 =DMIN(A4:C10,"Age",B1:B3) : Calculates the minimum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. <br>Returns '''29''' as a result.
-=DMIN(A4:C10,3,A4:C10) : Calculates the minimum value in the range A4 to C10, from the cells in the Salary column for all the employees. <br>Returns '''4000''' as a result.
+=DMIN(A4:C10,3,C4:C10) : Calculates the minimum value in the range A4 to C10, from the cells in the Salary column for all the employees. <br>Returns '''4000''' as a result.
 ==Related Videos==

@@ Line 28: / Line 28: @@
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
 | class="sshl_f" | '''Name'''
 | class="sshl_f" | '''Age'''
 | class="sshl_f" | '''Salary'''
 | class="sshl_f" | '''Age'''
-|- class="odd"
+|- class="even"
 | class="sshl_f" |
 | class="sshl_f" | &lt;40
 | class="sshl_f" | &gt;5000
 | class="sshl_f" | &gt;32
-|- class="even"
+|- class="odd"
 | class="sshl_f" |
 | class="sshl_f" | &gt;30
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | '''Name'''
 | class="sshl_f" | '''Age'''
 | class="sshl_f" | '''Salary'''
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
 | class="sshl_f" | John
 | class="sshl_f" | 34
 | class="sshl_f" | 5500
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Bill
 | class="sshl_f" | 35
 | class="sshl_f" | 6500
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
 | class="sshl_f" | Clark
 | class="sshl_f" | 29
 | class="sshl_f" | 7000
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Bob
 | class="sshl_f" | 45
 | class="sshl_f" | 9000
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
 | class="sshl_f" | Susan
 | class="sshl_f" | 37
 | class="sshl_f" | 4000
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
 | class="sshl_f" | Jill
 | class="sshl_f" | 45
@@ Line 79: / Line 95: @@
 |}
-=DMIN(A4:C10,"Salary",D1:D2) : Calculates the minimum value in the range A4 to C10, from the cells in the Salary column where Age>32. ''Returns '4000''' as a result.
+=DMIN(A4:C10,"Salary",D1:D2) : Calculates the minimum value in the range A4 to C10, from the cells in the Salary column where Age>32. <br>Returns '''4000''' as a result.
-=DMIN(A4:C10,2,A1:A3) : Calculates the minimum value in the range A4 to C10, from the cells in the second column (Age) for all employees. ''Returns '29''' as a result.
+=DMIN(A4:C10,2,A1:A3) : Calculates the minimum value in the range A4 to C10, from the cells in the second column (Age) for all employees. <br>Returns '''29''' as a result.
-=DMIN(A4:C10,"Age",B1:B3) : Calculates the minimum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. ''Returns '29''' as a result.
+=DMIN(A4:C10,"Age",B1:B3) : Calculates the minimum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. <br>Returns '''29''' as a result.
-=DMIN(A4:C10,3,A4:C10) : Calculates the minimum value in the range A4 to C10, from the cells in the Salary column for all the employees. ''Returns '4000''' as a result.
+=DMIN(A4:C10,3,C4:C10) : Calculates the minimum value in the range A4 to C10, from the cells in the Salary column for all the employees. <br>Returns '''4000''' as a result.
 ==Related Videos==

← Older revision		Revision as of 20:31, 17 April 2015
Line 86:		Line 86:

	=DMIN(A4:C10,3,A4:C10) : Calculates the minimum value in the range A4 to C10, from the cells in the Salary column for all the employees. ''Returns '4000''' as a result.		=DMIN(A4:C10,3,A4:C10) : Calculates the minimum value in the range A4 to C10, from the cells in the Salary column for all the employees. ''Returns '4000''' as a result.
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|eiIAd5xU3Vo\|280\|center\|DMIN}}

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

← Older revision		Revision as of 21:07, 24 November 2013
Line 84:		Line 84:

	=DMIN(A4:C10,"Age",B1:B3) : Calculates the minimum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. ''Returns '29''' as a result.		=DMIN(A4:C10,"Age",B1:B3) : Calculates the minimum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. ''Returns '29''' as a result.
		+
		+	=DMIN(A4:C10,3,A4:C10): Calculates the minimum value in the range A4 to C10, from the cells in the Salary column for all the employees. ''Returns '4000''' as a result.

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