Microsoft Office Forums - View Single Post - [Solved] If Statement with "and" and "Or

Thread: [Solved] If Statement with "and" and "Or

View Single Post

Old

05-21-2018, 06:45 PM

Formd

Formd is offline

Formd uses Windows 7 32bit

Windows 7 32bit Formd uses Office 2007

Formd uses Office 2007

Office 2007

Advanced Beginner

The original poster

Join Date: Feb 2015

Location: TX

Posts: 46

Formd is on a distinguished road

Default

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

Reply With Quote