Home > Articles

  • Print
  • + Share This
This chapter is from the book

DMIN

DMIN extracts the lowest value that meets the specified criteria.

=DMIN(database,field,criteria)

The DMIN function looks up the lowest value in a range or database. The database is the cell reference range or named range of the database and the field is referenced as the column number from left to right. The criteria is a range that is referenced and the function operates from the parameters set. The field can also be a cell reference. The DMIN function works the same way as the DMAX function. See DMAX for an example. See also the CD-ROM included with this book.

  • + Share This
  • 🔖 Save To Your Account