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, 02:37 PM

macropod

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

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,514

It's not at all clear what you want. There are four possible conditions; viz.:
• Rep = "" & Role = Rec, Rpt or Ord
• Rep = "" & Role <> Rec, Rpt or Ord
• Rep <> "" & Role = Rec, Rpt or Ord
• Rep <> "" & Role <> Rec, Rpt or Ord

So far you seem to have assigned only:
• Rep = "" & Role = Rec, Rpt or Ord outputs «Address»
• Rep = "" & Role <> Rec, Rpt or Ord
• Rep <> "" & Role = Rec, Rpt or Ord outputs «AltAdd»
• Rep <> "" & Role <> Rec, Rpt or Ord

What is the required output for each condition?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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