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

STDEV ignores blank cells, logical values or text so maybe some of your
numbers are text if you don't get what you expect,also how did you test a
blank range, STDEV needs 2 numbers or else it will return a #DIV/0! error?
Are you using some custom format that doesn't display zeros or have you
linked to blank cells (that will always return zero)


--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Stan Banner" wrote in message
news:a5KQf.132882$sa3.31565@pd7tw1no...
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