Reply
 
Thread Tools Display Modes
  #1   Report Post  
Adi.Master Adi.Master is offline
Junior Member
 
Posts: 1
Default NEED HELP !!!!! Add another formula to the Mail Merge Forumla IF

Hi.. I am new to this forum and have one question thats been bugging me 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 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 ""


Please help me cracking this one... Your quick and helpful response will be highly appreciated...
Waiting anxiously !!!
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiplying a mail merge formula Grazza215 Mailmerge 0 August 13th 13 04:42 PM
Mail Merge Formula - Logic Stumped MaxArk[_28_] Mailmerge 2 June 1st 10 11:11 AM
Footer linking forumla? Janette Microsoft Word Help 2 November 1st 07 12:33 PM
Forumla for converting dates into days Jim Tables 4 November 8th 05 08:51 PM
Word table forumla for calculating dates Leslie Draper Tables 1 June 27th 05 07:24 AM


All times are GMT +1. The time now is 04:57 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"