Microsoft Office Tutorials and References
In Depth Information
DMAX
The criteria is a range that is referenced and the function operates from the parameters set.
Notice the example in Figure 3.3, the DGET formula looks up the field or Rate 2, and applies the
criteria in B15:F16 to lookup Product C. Please note that if more than one value meets the
specified criteria, DGET returns a #NUM! error.
A
Database range
Figure 3.3
The DGET function
finds a number at two
intersecting points.
C
The criteria or
product referenced
B
Field referenced as a column heading
DMA DMAX extracts the highest value that meets the specified criteria.
=DMAX(database,field,criteria)
The DMAX function looks up the highest 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. For example, notice the
formula in Figure 3.4 that references the column heading Minnesota in cell F23. The criteria
looks up the highest temperature less than 20 degrees. If you type a new column heading in
the cell reference F23, the DMAX formula responds. The cell reference could be Minnesota or 1,
meaning column one of the database, either way works. You can use cell references for the
field in all Database functions. When you look at the figure, you’ll notice that Minnesota in cell
F23 is not case sensitive, however, the criteria headings are.
Search JabSto ::




Custom Search