mike scott wrote:
On 7 Jun 2008 at 11:25, Jerry Feldman wrote:
On Sat, 07 Jun 2008 13:57:03 +0100
"mike scott" <[EMAIL PROTECTED]> wrote:
Not so, in fact following that discussion all my columns are now 300
entries long, which should see me through. But one day, someone
/will/ accidentally go over such a preset length, not notice, and pay
the price with erroneous results.
(And the help file does need clarifying IMO)
I personally prefer something relatively clean. While it is good to
know that empty cells are not included, considering that someone else
may have to use the worksheet is a very good consideration. In my case,
....
...
And I've just spotted that a space character (which of course /looks/
like an empty cell) seems to behave like a numeric zero. Ouch!!!
In what way does a space or a character behave like a zero? I've just
tried putting in a cell in the midst of some numbers, first with a
single letter, than with a space. I tried the SUM function, the AVERAGE
function, and the STDEV function, and all of these ignored the cell with
text.
I'm not saying there are no instances where a space character isn't
treated like a zero -- just that based on a quick test with the
functions that you seemed to express some interest in, it is ignored,
rather than treated like a zero.
