View Single Post
  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Can I compare more than two merge field values using =AND or =

Did you enter all the brackets with CTRL+F9?

--

Graham Mayor - Word MVP

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



8Leonie8 wrote:
Hi there,

I'm trying to use the OR function in my Word 2003 document (dutch
version), but I can't get it to work.

I get the following reaction when merging to a new document: Error!
Unknown operator in precondition

Does anyone have an idea why this doesn't work??


"macropod" wrote:

Hi Rhiannon,

You can build a multiple AND test this way:
{IF{={IF{MERGEFIELD 1}= "Y" 1 0}*{IF{MERGEFIELD 2} 2 1
0}*{IF{MERGEFIELD 3}= "text" 1 0}}= 1 "True Text" "False Text"}

Similarly, you can build a multiple OR test this way:
{IF{={IF{MERGEFIELD 1}= "Y" 1 0}+{IF{MERGEFIELD 2} 2 1
0}+{IF{MERGEFIELD 3}= "text" 1 0}} 0 "True Text" "False Text"}

--
Cheers
macropod
[Microsoft MVP - Word]


"Rhiannon" wrote in message
...
I'm working in Word 2007. I have a list of mergefields (anywhere
between 3 and 7 depending) that I would like to test the values of
- if all of them come back true, return one block of text, else
return another block of text. It works fine when I try and compare
the values of two mergefields:

{IF { = AND ( { COMPARE {Mergefield 1} = "Y"}, {COMPARE {mergefield
2} 2 } ) } = 1 "true" "false" }

but as soon as I try and compare the values of three or more
mergefields:

{IF { = AND ( { COMPARE {Mergefield 1} = "Y"}, {COMPARE {mergefield
2} 2 }, { COMPARE {mergefield 3" = "text" } ) } = 1 "true"
"false" }

it breaks. Is there a way to expand beyond two comparisons, using
either the =AND or the =OR formulas? I'd rather not start nesting
piles of these if I can help it. Thanks muchly!!