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

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
"Compass Rose" wrote in message
...
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

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

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


Peter Jamieson wrote:
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
"Compass Rose" wrote in
message ...
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