If Statement with "and" and "Or

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

FAQ

Mark Forums Read

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,467

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]

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 09:00 AM.