CMAX

**Syntax:** **CMAX( argumentlist, C)**

*argumentlist* = any combination of cells or ranges

*C* = a constraint expression

**CMAX** returns the maximum value among its arguments which
satisfy the constraint *C*. Blank cells and cells
containing strings are not counted.

**Examples:**

**CMAX**(A1..A6, #**SUM**(A11, A12)) = 56, where A1..A6 are 4,
56, 33, 100, 0, -1; A11=50 and A12=50

**CMAX**(S3..S7, #0) =-1, where S3..S7 = -1, -4, -99, -20,
and -1.5

**CMAX**(F1..F25, #D1#D2) = 1.99, where the maximum of
the values in range F1..F25; are less than D1 or greater
than D2.

**Excel function:** *N/A*

Grey Trout Software

02 March 2003