writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 84:
Line 84: − + + +
→Examples
=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,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.
=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.
== See Also ==
== See Also ==