NEED HELP !!!!! Add another formula to the Mail Merge Forumla IF

[Adi.Master]

Hi.. I am new to this forum and have one question thats been bugging m
since a month... hope to get a satisfying solution...

I have a template which inputs data from an excel sheet....

I have entered the IF formula as follows:

{IF {MERGEFIELD State} = "A" "My Paragraph 1" "{IF {MERGEFIELD State}
"B" "My Paragraph 2" " "} "}

what I am trying to do here is that I want to add an OR condition to th
above formula... for eg:

IF "MERGEFIELD State" = A OR "MERGEFIELD State" = C THEN 'My Paragrap
1' ELSEIF "MERGEFIELD State" = B OR "MERGEFIELD State" = D THEN 'M
Paragraph 2' ELSE ""


Please help me cracking this one... Your quick and helpful response wil
be highly appreciated...
Waiting anxiously !!

 

[Lisa Wilke-Thissen]

Hi,

Hi.. I am new to this forum

this is NOT a forum, it is a newsgroup. But this newsgroup is nearly dead.
So you better would ask your questions in a forum like
http://answers.microsoft.com/en-us/office/forum/word?tab=QnA

what I am trying to do here is that I want
to add an OR condition to the above formula...
for eg:

IF "MERGEFIELD State" = A
OR "MERGEFIELD State" = C
THEN 'My Paragraph 1'
ELSEIF "MERGEFIELD State" = B
OR "MERGEFIELD State" = D
THEN 'My Paragraph 2' ELSE ""

Have a look at this article:
"How to use nested IF fields in a mail-merge document in Word 2000 or Word
2002"
http://support.microsoft.com/kb/214827/en-us

IF State = A then Paragraph 1
otherwise
IF State = C then Paragraph 1
otherwise
IF State = B then Paragraph 2
otherwise
IF State = D then Paragraph 2

You also can use COMPARE and OR fields:
"How to specify multiple conditions with a nested IF field in Word"
http://support.microsoft.com/kb/211363/en-us

IF = OR
( COMPARE State = A;
COMPARE State = C )
then Paragraph 1
otherwise
IF = OR
( COMPARE State = B;
COMPARE State = D )
then Paragraph 2