Mutiple Conditions with a Nested IF statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sal - 05 Jul 2004 03:52 GMT

I would like to test whether multiple (more than 2)
conditions are met before returning the true value - I
have tried to do this with nested "AND" and "COMPARE"
statements nested in IF statements (as below), however
they only seem to work where there are only two
conditions - any more it always returns the false value

Can anyone suggest how I can overcome my problem?

{IF {=AND({COMPARE {MERGEFIELD One}= "1"} , {COMPARE
{MERGEFIELD Two}<> ""} , {COMPARE {MERGEFIELD Three}

> "2"})} = 1 "Hello" ""}

Thanks

Sal

Reply to this Message

macropod - 05 Jul 2004 11:07 GMT

Hi Sal,

Take a look at the Word document at:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=365442
(url all one line)

There you'll find examples of how to use more than two conditions.

Cheers

> I would like to test whether multiple (more than 2)
> conditions are met before returning the true value - I
[quoted text clipped - 12 lines]
>
> Sal

Reply to this Message

Graham Mayor - 05 Jul 2004 11:45 GMT

Use a nested construction as follows:

{IF{Mergefield One} = 1 "{IF {Mergefield Two} <> "" "{IF{Mergefield Three} >
2 "Hello" ""}" ""}" ""}

Signature

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

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

> I would like to test whether multiple (more than 2)
> conditions are met before returning the true value - I
[quoted text clipped - 12 lines]
>
> Sal

Reply to this Message

Rate this thread: