DMIN Function Explained
The DMIN function in Microsoft Excel returns the smallest number in a range of cells, based on a given criteria. It takes three arguments: database, field, and criteria. The database argument is a range of cells that contains the data to be evaluated. The field argument is the column number in the database that contains the data to be evaluated. The criteria argument is a range of cells that contains the criteria used to evaluate the data.
DMIN Function Syntax
DMIN(database, field, criteria)
- database: The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields.
- field: The column number in the database that contains the data you want to find the minimum value of.
- criteria: The range of cells that contains the criteria in the form of an expression, cell references, or text that defines which cells will be checked.