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.