limits on if statements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robseym - 05 Mar 2006 19:03 GMT

Is there a limit to how many 'If_then_else' statements a mail merge document
can contain?

Rob

Reply to this Message

Graham Mayor - 06 Mar 2006 06:59 GMT

Only if you try and nest them.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Is there a limit to how many 'If_then_else' statements a mail merge
> document can contain?
>
> Rob

Reply to this Message

Robseym - 06 Mar 2006 21:05 GMT

Thanks for that. it begs two further questions:

1) what is the limit on nested if statements?
2) How would you count the number of nested statements in the following
examples? - not written using the actual code:

I think the first statement is three nested, the second statement is only
two and the third contains no nested statements but I could be wrong.

1. IF([conditon], "text", "IF([condition2], "text", "IF([condition3],
"text", "")"" )

2. IF([conditon], "text", "IF([condition2], "text", "")IF([condition3],
"text", "")" )

3. IF([conditon], "text", "")IF([condition2], "text", "")IF([condition3],
"text", "")

Hope you can help as I am compiling a monster doc and don't want any nasty
surprises.

Rob

> Only if you try and nest them.
>
> > Is there a limit to how many 'If_then_else' statements a mail merge
> > document can contain?
> >
> > Rob

Reply to this Message

macropod - 07 Mar 2006 09:59 GMT

You can nest up to 20 IF fields in Word.

As for your examples, Word fields aren't coded quite like that. Turning them
into the correct structure:
1. {IF{conditon1}= TRUE "True text 1" {IF{conditon2}= TRUE "True text 2"
{IF{conditon3}= TRUE "True text 3" "False Text"}}}
all 3 conditions are nested
2. {IF{conditon1}= TRUE "True text 1" {IF{conditon2}= TRUE "True text 2"
"False Text 1"}{IF{conditon3}= TRUE "True text 3" "False Text 2"}}
the first two conditions are nested.
3. {IF{conditon1}= TRUE "True text 1" "False Text 1"}{IF{conditon2}= TRUE
"True text 2" "False Text 2"}{IF{conditon3}= TRUE "True text 3" "False Text
3"}
no conditions are nested.

If any of the 'FALSE' strings has no text, you can omit the double quotes
for them also. Empty 'TRUE' text strings must retain the double quotes,
though.

Cheers

> Thanks for that. it begs two further questions:
>
[quoted text clipped - 25 lines]
> > >
> > > Rob

Reply to this Message

Robseym - 07 Mar 2006 14:08 GMT

Thank macropod looks like i'm going to be ok with that. I knew the coding was
different but I just wanted to make it easier to see, but that should help
others who look at this post.

Rob

> You can nest up to 20 IF fields in Word.
>
[quoted text clipped - 46 lines]
> > > >
> > > > Rob

Reply to this Message