If Statement with "and" and "Or

		Microsoft Office Forums > Microsoft Word > Mail Merge
If Statement with "and" and "Or

FAQ

Thread Tools

Display Modes

05-21-2018, 09:55 AM

Formd

Windows 7 32bit If Statement with "and" and "Or

Office 2007

Advanced Beginner

Join Date: Feb 2015

Location: TX

Posts: 49

This is Great. But it only should apply “if” {MERGEFIELD Rep} is blank. How can I include IF {MERGEFIELD Rep} = "" THEN do this:

{IF{={IF{MERGEFIELD Role}= "Rec*" 1 0}+{IF{MERGEFIELD Role}= "Rpt*" 1 0}+{IF{MERGEFIELD Role}= "Ord*" 1 0} \# 0}> 0 {MERGEFIELD Address} {MERGEFIELD AltAdd}}.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine "sort within groups" and "identify duplicate/unique values" in two different variables.	civilcervant	Excel	3	06-12-2017 07:27 AM
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N	mikey386	Excel	2	12-11-2014 01:14 PM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
IF statement just generates text "MERGEFIELD" in document - what am I doing wrong?	Eri	Mail Merge	1	03-03-2012 03:03 PM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:52 PM.