writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 20:
Line 20: + + + Line 78:
Line 81: − +
no edit summary
== Examples ==
== 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.
<div id="2SpaceContent" class="zcontent" align="left">
<div id="2SpaceContent" class="zcontent" align="left">
=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,"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 names. ''Returns '45''' 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,"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.