Re: Calculations that create "blank" results

From: RSteffel (anonymous_at_discussions.microsoft.com)
Date: 05/12/04 

Date: Tue, 11 May 2004 19:09:22 -0700

Thanks. I've been looking for a fix for a long time, since
it seems intuitive that it should be possible. :(

BTW, using NA() will sort of work, but charting then uses
lines in inappropriate locations to connect unconnected
points. Oh well.
>-----Original Message-----
>
>"RSteffel" <anonymous@discussions.microsoft.com> a écrit
dans le message de
>news: 4C766606-4439-419A-97D6-
6584308D1B85@microsoft.com...
>> For purposes of charting large amounts of data, I need
to test for certain
>conditions, and then have the result appear as a blank
cell. If I use "", or
>0, the charted data shows up as zero. I really just want
these data to not
>show up on the chart. And I need to use data formats that
include lines, so
>using a negative number and then suppressing values less
than zero will not
>provide the result I'd like.
>>
>> I think I need a Blank() function.
>
>You do, and its absence, discussed many time in this NG,
indicates a
>fundamental deficiency that may lead to doubts about the
suitability of this
>software for really serious applications.
>
>The workaround in the post by Peo Sjoblom is neat, but it
works around a
>problem that should never have existed, even in the first
version of XL.
>
>Regards
>
>>
>> Any ideas?
>>
>> Thanks
>
>
>.
>