If Statement with "and" and "Or

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

FAQ

Thread Tools

Display Modes

#10

05-21-2018, 06:45 PM

Formd

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

Office 2007

Advanced Beginner

Join Date: Feb 2015

Location: TX

Posts: 49

Here is the required output

• Rep = "" & Role = Rec, Rpt or Ord outputs «Altname» and «AltAdd»
• Rep = "" & Role <> Rec, Rpt or Ord outputs DONOTHING
• Rep <> "" & Role = Rec, Rpt or Ord outputs «Address»
• Rep <> "" & Role <> Rec, Rpt or Ord outputs DO NOTHING

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