D

#### daapower

I calculate the standard deviation for just the negative numbers

without selecting them manually.

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

D

I calculate the standard deviation for just the negative numbers

without selecting them manually.

R

formula field), use the following formula where A1:A9 is you

range/array of positive and negative numbers:

=STDEV(IF(A1:A9<0,A1:A9))

(which will look like {=STDEV(IF(A1:A9<0,A1:A9))} once entered a

mentioned above)

To

D

thanks, works great