Difference between revisions of "Manuals/calci/DMIN"

From ZCubes Wiki
Jump to navigation Jump to search
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,"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==
 
==Related Videos==

Revision as of 21:07, 9 October 2015

DMIN(database, field, criteria)

  • Where 'database' 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() displays the smallest number in a column of a list or database that matches the specified criteria.

Description

DMIN(database, 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).
  • 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.

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.

A B C D
1 Name Age Salary Age
2 <40 >5000 >32
3 >30
4 Name Age Salary
5 John 34 5500
6 Bill 35 6500
7 Clark 29 7000
8 Bob 45 9000
9 Susan 37 4000
10 Jill 45 8000

=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,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,"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,C4: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

DMIN

See Also

References