Thread: [Solved] If Statement with "and" and "Or
View Single Post
 
Old 05-21-2018, 09:35 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
In that case, what you need is:

{IF{={IF{MERGEFIELD Role}= "Rec*" 1 0}+{IF{MERGEFIELD Role}= "Rpt*" 1 0}+{IF{MERGEFIELD Role}= "Ord*" 1 0} \# 0}> 0 {IF {MERGEFIELD Rep}= "" "{MERGEFIELD AltName}¶
{MERGEFIELD AltAdd}" {MERGEFIELD Address}}}
or:
{IF{={IF«Role»= "Rec*" 1 0}+{IF«Role»= "Rpt*" 1 0}+{IF«Role»= "Ord*" 1 0} \# 0}> 0 {IF « Rep»= "" "« AltName»¶
« AltAdd»" « Address»}}
where the ¶ is a reall paragraph break or line break.

In effect, I've replaced:
{MERGEFIELD Address} {MERGEFIELD AltAdd}
in post 6 with:
{IF {MERGEFIELD Rep}= "" "{MERGEFIELD AltName}¶
{MERGEFIELD AltAdd}" {MERGEFIELD Address}}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote