 Formula Engine Reference Guide |
|
Back to Class Index
CMAX(argumentlist, C)
This function returns the maximum value among its arguments which satisfy the constraint C. Blank cells and cells containing strings are not counted.
Parameters
argumentlist
Any combination of cells or ranges
C
A constraint expression
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.