Microsoft Office Tutorials and References
In Depth Information
DMIN
A
Database range
Figure 3.4
The DMAX function
finds the maximum
value in a database
range with criteria or
parameters.
C
The greatest
temperature less
than 20 degrees
B
Field referenced
as a cell reference
DMI 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 topic.
DPRODUCT
DPRODUCT returns the product of multiplying the values that meet the specified criteria.
=DPRODUCT(database,field,criteria)
The DPRODUCT function returns the product of multiplying the values that meet certain criteria
you specify. In the syntax for this function, the database is the cell reference range or named
range of the database; 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. In Figure 3.5, the product is the multiplication of the cost
and the markup. As well, the parameters are Unit 1 with a cost greater than two dollars and a
markup less than 30%. The product is 2.88. Of course this is a simple example to illustrate
parameters and the operation of the function.
Search JabSto ::




Custom Search