|
PureBytes Links
Trading Reference Links
|
Try using == instead of = in your IIF statements.
For example,
IIF(templ = True
should be coded as
IIF(templ == True
David Jennings wrote:
>
> I have a piece of code which seems straight forward but I seem to be
> struggling. i have written it in a number of different ways e.g. using
> if statements in a loop and using iif statements as below. However,
> I seem to have a problem which ever way I write it insofar that
> Test1L & Test1S fail to evaluate correctly. Herewith a snippet:
>
>
> t1 = XPermK - XpermD;
>
> inter2 = abs(XPermK - XpermD);
>
>
>
> TempL = IIf (XpermD[j] >UpperBound *AND* XPermK[j] >UpperBound,
> *True*,*False*);
>
> Test1L = IIf(tempL = *True* *AND* abs(t1) < 2, *True*, *False*);
>
> Test2L= IIf(XpermD < Lowerbound *AND* XPermK < Lowerbound
> *AND* t1 > 2.0,*True*, *False*);
>
> Test3L=IIf(XPermK >Lowerbound *AND* XPermK >
> XPermD,*True*,*False*);
>
>
>
> Test1S = IIf(XpermD < Lowerbound *AND* XPermK < Lowerbound
> *AND* abs(t1) < 2,*True*,*False*);
>
> Test2S = IIf(XpermD > UpperBound *AND* XPermK[k] > UpperBound
> *AND* t1> 2,*True*,*False*);
>
> Test3S = IIf(XPermK < UpperBound *AND* XPermK <
> XPermD,*True*,*False*);
>
>
>
> XPermLong = IIf(Test1L = *True* *OR* Test2L[j] = *True* *OR*
> Test3L[j] = *True*,*True*, *False*);
>
>
>
> XpermShort =IIf(Test1S = *True* *OR* Test2S = *True* *OR*
> Test3S = *True*,*True*,*False*);
>
>
>
> For instance Test1l can return false and Test1L will evaluate as true.
>
> Most grateful if someone could help me understand why I have it around
> my neck.
>
Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.15.4/563 - Release Date: 12/2/2006 9:59 AM
|