OR in a mergefield?

[Compass Rose]

I would like to use OR in an If...then...else... Word Field.

If {MERGEFIELD Company} = "Company A" OR {MERGEFIELD Company} = "Company B"
OR {MERGEFIELD Company} = "Company C" then......

Is it possible, and if so, what is the correct syntax?

TIA
David

 

[Peter Jamieson]

There is no OR in the IF field, but there are other ways to achieve the
same effect, depending on exactly what you need.

{ IF "{ MERGEFIELD Company }" = "Company A" "X" "Y" }
{ IF "{ MERGEFIELD Company }" = "Company B" "X" "Y" }

is one way that may be enough in simple situations.

{ COMPARE "{ MERGEFIELD Company }" = "Company A" } returns 1 if Company is
"Company A", 0 otherwise, so you can use

{ IF { =or({ COMPARE "{ MERGEFIELD Company }" = "Company A" },{ COMPARE
"{ MERGEFIELD Company }" = "Company B" }) } = 1 "X" "Y" }

or just use addition, e.g.

{ IF { ={ COMPARE "{ MERGEFIELD Company }" = "Company A" }+{ COMPARE "{
MERGEFIELD Company }" = "Company B" } } > 0 "X" "Y" }

Peter Jamieson

 

[Graham Mayor]

There is an alternative method for testing for a value in fields shown at
http://www.gmayor.com/formatting_word_fields.htm

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


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