Thread: [Solved] If Statement with "and" and "Or
View Single Post
 
Old 05-21-2018, 02:37 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote