Using OR in an IF statement

[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

 

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Kathy Webster]

Perfect! thank you!
Kathy

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