[Kathy Webster]

I want to say: IF MERGEFIELD region = 1 or IF MERGEFIELD state = 3, then
type "You qualify."

I know how to do it if there is only 1 criteria, but can't figure out the OR
part:

{ IF MERGEFIELD region = 1 "You qualify." }

TIA,
Kathy

[Peter Jamieson]

In this case you could use

{ IF { MERGEFIELD region } = 1 "You qualify" "{ IF { MERGEFIELD state } = 3
"You qualify" "" }" }

You can also use { COMPARE }, e.g. if region = 1 then

{ COMPARE { MERGEFIELD region } = 1 }

results in 1 if region = 1 and 0 otherwise. So you can then use

{ IF "{ COMPARE { MERGEFIELD region } = 1 }{ COMPARE { MERGEFIELD state } =
3 }" "00" "You qualify" "" }

or if you prefer you can use an { = } field to do either an "or" or a
calculation, then test the result. The approach that is most easily extended
to more conditions is probably

{ IF { ={ COMPARE { MERGEFIELD region } = 1 } + { COMPARE { MERGEFIELD
state } = 3 } } 0 "You qualify" "" }

All the {} need to be the special field braces that you can insert using
ctrl-F9

Peter Jamieson



"Kathy Webster" wrote in message
...
I want to say: IF MERGEFIELD region = 1 or IF MERGEFIELD state = 3, then
type "You qualify."

I know how to do it if there is only 1 criteria, but can't figure out the
OR part:

{ IF MERGEFIELD region = 1 "You qualify." }

TIA,
Kathy

[Graham Mayor]

See also Testing for a value in one of several fields.at
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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


Kathy Webster wrote:
I want to say: IF MERGEFIELD region = 1 or IF MERGEFIELD state = 3,
then type "You qualify."

I know how to do it if there is only 1 criteria, but can't figure out
the OR part:

{ IF MERGEFIELD region = 1 "You qualify." }

TIA,
Kathy

[Kathy Webster]

Perfect! thank you!
Kathy

"Peter Jamieson" wrote in message
...
In this case you could use

{ IF { MERGEFIELD region } = 1 "You qualify" "{ IF { MERGEFIELD state } =
3 "You qualify" "" }" }

You can also use { COMPARE }, e.g. if region = 1 then

{ COMPARE { MERGEFIELD region } = 1 }

results in 1 if region = 1 and 0 otherwise. So you can then use

{ IF "{ COMPARE { MERGEFIELD region } = 1 }{ COMPARE { MERGEFIELD state }
= 3 }" "00" "You qualify" "" }

or if you prefer you can use an { = } field to do either an "or" or a
calculation, then test the result. The approach that is most easily
extended to more conditions is probably

{ IF { ={ COMPARE { MERGEFIELD region } = 1 } + { COMPARE { MERGEFIELD
state } = 3 } } 0 "You qualify" "" }

All the {} need to be the special field braces that you can insert using
ctrl-F9

Peter Jamieson



"Kathy Webster" wrote in message
...
I want to say: IF MERGEFIELD region = 1 or IF MERGEFIELD state = 3, then
type "You qualify."

I know how to do it if there is only 1 criteria, but can't figure out the
OR part:

{ IF MERGEFIELD region = 1 "You qualify." }

TIA,
Kathy