next up previous contents index
Next: CODE Up: A. Function Reference Previous: CMAX   Contents   Index


CMIN

Syntax: CMIN(argumentlist, C)

argumentlist = any combination of cells or ranges
C = a constraint expression

CMIN returns the minimum value among its arguments which satisfy the constraint C. Blank cells and cells containing strings are not counted.

Examples:

CMIN(A1..A6, #$<$SUM(A11, A12)) = -1, where A1..A6 are 4, 56, 33, 100, 0, -1 and A11=50 and A12=50

CMIN(S3..S7, #$<$0) = -99, where S3..S7 = -1, -4, -99, -20, and -1.5

CMIN(F1..F25, #$<$D1$\vert\vert$#$>$D2) = .99, where the minimum of the values in range F1..F25; are less than D1 or greater than D2.

Excel function: N/A


next up previous contents index
Next: CODE Up: A. Function Reference Previous: CMAX   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003