# Manuals/calci/DMAX

DMAX (Array,Field,Criteria)

• Where 'Array' is the range of cells that makes up the list or database
• 'Field' shows which column is used in the function and
• 'Criteria' is the range of cells that contains the specified condition.
• DMAX(),returns the maximum value from selected database entries.

## Description

DMAX (Array,Field,Criteria)

• This function returns the largest number from the database that satisfies the given condition.
• A 'Field' argument can be expressed as "Salary" (a column name) or 3(position of the column).
• Criteria can be any range on the Calci with minimum of one column and at least one row indicating the condition.
• The Criteria columns should not overlap the list of data.

## Examples

Consider the following table with Employee names, Age and Salary columns.

Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.

 A B C D 1 Name Age Salary Age 2 <40 >5000 >32 3 >30 4 Name Age Salary 5 John 34 5500 6 Bill 35 6500 7 Clark 29 7000 8 Bob 45 9000 9 Susan 37 4000 10 Jill 45 8000

=DMAX(A4:C10,"Salary",D1:D2) : Calculates the maximum value in the range A4 to C10, from the cells in the Salary column where Age>32.
Returns 9000 as a result.

=DMAX(A4:C10,2,A1:A3) : Calculates the maximum value in the range A4 to C10, from the cells in the second column (Age) for all employees.
Returns 45 as a result.

=DMAX(A4:C10,"Age",B1:B3): Calculates the maximum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30].
Returns 45 as a result.

=DMAX(A4:C10,3,A4:C10): Calculates the maximum value in the range A4 to C10, from the cells in the Salary column for all the employees.
Returns 9000 as a result.

DMAX