 Formula Engine Reference Guide |
|
Back to Class Index
CSTD(argumentlist, C)
This function returns the standard deviation (N weighting) of its arguments that 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
CSTD(A1..A3, #<10) = 2.6246693
where A1..A3 are 1, 2, and 7
CSTD(Y1..Y5, #25) = 6.6833126
where Y1..Y5 = 22, 24, 29, 34, and 45