View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:

=2 * STDEV(rng)

In article ,
"Li" wrote:

Pls advise how to can I calculate 2 standard deviation in Excel? The StDev
function only gives 1 standard deviation.
Thanks,
Li