Re: Calculations that create "blank" results

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
>
>
>.
>

Relevant Pages

  • Re: to keep you from having difficulties of greater proportions -- Ray (the nice guy)
    ... what Zero fantasized I said but can't of course cite: ... others make "some sort of claim to be an expert of some sort" are the ... citing his own experiences. ... Which is to say that you said without qualification that I was ...
    (misc.writing)
  • RE: Setting Range by calculation
    ... 'Return the address of cell containing zero ... 'Or return the row of the cell containing zero ... As far the sort, I tried your code, but was not sure how to set "i" so I set ... In my working tab I have references to the pasted tab for up to 200 ...
    (microsoft.public.excel.programming)
  • Re: strange record sorting behavior
    ... In this case I have a script that organizes records in t_draft so the ... contour of crime you're incorrigible ... I ain't no nice guy zero hour ... or ways I try sort by name this arrangement persists. ...
    (comp.databases.filemaker)
  • Re: CListCtrl sort not working
    ... The two parameters coming to my callback function are always zero. ... Unfortunately the FAQ doesn't suggest how this should be used. ... a subsequent sort doesn't work because now the data item no longer matches the actual index of the row item. ... I suppose I could change the data items depending on whether I pass back a positive, zero or negative value, but it seems to me I shouldn't have to do that and also, it seems to me that the data item loses it's usefulness if I just have to store an index in it. ...
    (microsoft.public.vc.mfc)
  • Re: to keep you from having difficulties of greater proportions -- Ray (the nice guy)
    ... what Zero fantasized I said but can't of course cite: ... so perhaps i was combining my past experiences with your posing-as- ... Which makes me about as much like Sylvia as a justice of the Supreme ... others make "some sort of claim to be an expert of some sort" are the ...
    (misc.writing)