View Single Post
  #8   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 =

Put a space either side of
thus
{IF 3 0 "True text" "False text"}

--

Graham Mayor - Word MVP

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



8Leonie8 wrote:
Yes I did. I even followed the help Peter Jamieson has given in the
topic titled "=AND" He says:

then use right-click and toggle field codes to see the result of that
part of the whole construct to see if you can detect which part is
causing the problem.

If I click toggle field code(I'm not sure if that's the correct
English word for this option, I'm translating from the Dutch version
of Word), it seems every part of the function is working. When I
click toggle field code for the different mergefields first I get:
{ IF { =1+1+1}0 "True text" "False text"}
If I go a step further and click toggle field code for {=1+1+1} I get:
{ IF 30 "True text" "False text"}. So far so good, you'd say, but
when I click toggle field code for the last step I get:
Error! Unknown operator in precondition

Hope I've explained my actions in an understandable way, otherwise
let me know.

gr leonie



"Graham Mayor" wrote:

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!!