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, 09:55 AM

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: 49

Formd is on a distinguished road

Default

This is Great. But it only should apply “if” {MERGEFIELD Rep} is blank. How can I include IF {MERGEFIELD Rep} = "" THEN do this:

{IF{={IF{MERGEFIELD Role}= "Rec*" 1 0}+{IF{MERGEFIELD Role}= "Rpt*" 1 0}+{IF{MERGEFIELD Role}= "Ord*" 1 0} \# 0}> 0 {MERGEFIELD Address} {MERGEFIELD AltAdd}}.

Reply With Quote