|
PureBytes Links
Trading Reference Links
|
>>>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.
mike
|