View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Banner
 
Posts: n/a
Default Standard Deviation

Hi:
I have tried to use STDEV() to find the Standard Deviation of a large range
of cells that contains many blanks, assuming that the blanks would be
ignored, however, I have found that the blanks were given the value of 0. I
tested this by trying to find the Standard Deviation of a range of blank
cells and every cell was given the value of 0. I must be doing something
wrong but I don't know what it is.
I hope that someone can help me out here.
Thanks

Stan