|
PureBytes Links
Trading Reference Links
|
Mike,
On Sun, 19 Oct 1997 05:24:16 -0400, you wrote:
>>>>Because of several reasons, I want to fill these gaps by a formula
>>>>e.g.
>>>> If(V=3D3D0 OR V=3D3D"N/A",PREV,V)
>>>>but, unfortunately, MS seemingly doesn't like this "N/A" in a
>>formula.
>>>>
>>>>My question:
>>>>How can I address these N/A values in a formula?
>>>>Or is there a work-around to set "missing values" e.g. to the
>>>>preceding values?
> if you selected the option to show holidays & weekends on your chart
>(for cycle analysis purpose) you would probably get these gaps showing up
>as n/a (not available).
>check this first- just another idea.
I did this, see my problem description from above:
>>In my data set of securities, some days are not available, because
>>these days were holidays. So MS (show holidays selected in the option
>>section) shows a "N/A" in the data window for these days.
But what do you think could be a solution for filling these gaps
(please, see above)??
mfg rudolf stricker
|
| Disclaimer: The views of this user are strictly his own.
|