 Formula Engine Reference Guide |
|
Back to Class Index
CVARS(argumentlist, C)
This function returns the sample variance (N-1 weighting) of its arguments which satisfy the constraint C. Blank cells and cells containing strings are not included.
Parameters
argumentlist
Any combination of cells or ranges
C
A constraint expression
Examples
CVARS(Y1..Y5, #<25) = 2
where Y1..Y5 = 22, 24, 29, 34, and 45
CVARS(A1..A3, #<C2E7) = 10.333333
where A1..A3 are 1, 2, 7, and C2 = 5 and E7 = 2