CMAX(<List>, C)

 

Description

This function returns the maximum value among its arguments that satisfy the constraint C.  Blank cells and cells containing strings are ignored.

 

Parameters

 

<List>

Any combination of cells or ranges.

 

C

A constraint expression.

 

Examples

 

CMAX(A1:A6, #<SUM(A11, A12)) = 56

Where A1:A6 = 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 the range F1:F25 that are less than D1 or greater than D2.