Re: Help! Nested IF
- From: "macropod" <macropod@xxxxxxxxx>
- Date: Fri, 08 Apr 2005 23:54:45 GMT
Hi Steve,
Your problem is that the spacing between the various expressions isn't
right. For example, after applying the IF tests, between the '=' and the
true results or between the true and false results. Consequently, you'll
only ever get the true result.
Try:
{IF{teight}= "CPI Rent" {INCLUDETEXT "c:\\template\\17.01A.doc"}
{IF{teight}= "%GRP without 5yrs" {INCLUDETEXT "c:\\template\\17.01A.doc"}
{IF{teight}= " %GRP with 5yrs" {INCLUDETEXT "c:\\template\\17.01A.doc"}
{INCLUDETEXT "c:\\template\\17.01B.doc"}}}}
Cheers
"Steve" <sclothier@xxxxxxxxx> wrote in message
news:d8d86a16.0504072103.75c88aeb@xxxxxxxxxxxxxxxxxxxxx
> Hello,
>
> I have been trying all day to figure this one out and I can't get it
> to work. I have three nested IF fields. The way I wrote it only the
> first two conditions seem to work properly it does not see the third.
> Here is what I have.
>
> {IF {REF "teight"} ="CPI Rent" {INCLUDETEXT
> "c:\\template\\17.01A.doc"}{IF {REF "teight"} ="%GRP without 5yrs"
> {INCLUDETEXT "c:\\template\\17.01A.doc"}{IF {REF "teight"} ="%GRP with
> 5yrs" {INCLUDETEXT "c:\\template\\17.01A.doc"}{INCLUDETEXT
> "c:\\template\\17.01B.doc"}}}}
>
> Only the first two conditions CPI Rent and %GRP without 5yrs work the
> third %GRP with 5yrs returns with the 17.01B when it should be 17.01A.
>
> I have 5 items in my dropdown box.
>
> What am i doing wrong?
>
> Thanks
>
> Steve
.
- References:
- Help! Nested IF
- From: Steve
- Help! Nested IF
- Prev by Date: Re: How do I create a table in a form that sums and refreshes itself?
- Next by Date: Re: avoid updating user dictionary
- Previous by thread: Help! Nested IF
- Next by thread: Scanned Signatures
- Index(es):
Relevant Pages
|
