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