next up previous contents index
Next: CMIN Up: A Function Reference Previous: CLEAN

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.


next up previous contents index
Next: CMIN Up: A Function Reference Previous: CLEAN

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999