next up previous contents index
Next: CSTDS Up: A. Function Reference Previous: COUPPCD   Contents   Index


CSTD

Syntax: CSTD(argumentlist, C)

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

CSTD returns the standard deviation (N weighting) of its arguments that satisfy the constraint C. Blank cells and cells containing strings are not counted.

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

Excel function: N/A


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