View Single Post
 
Old 12-10-2019, 11:52 AM
shawn.low@cox.net shawn.low@cox.net is offline Windows 10 Office 2016
Novice
 
Join Date: May 2019
Location: Aliso Viejo, CA.
Posts: 24
shawn.low@cox.net is on a distinguished road
Default "OR" condition within an IF Statement

I searched the forum for this but didn't find anything.


I need to have a Table populate in a Document. The Table needs to populate UNLESS the value of a referenced field (hence the "IF" statement) is one of three (3) numbers.


I know that's a bit confusing, sorry for that.


We have thousands of Lead Providers, but only three (3) of those thousands are considered "Brokers". If the Lead Provider Id is one of those three Brokers, the Table should not populate.


So I was going with this basic starting point:
{ IF {MERGEFIELD Opportunity_Affiliate_ID_Number \* MERGEFORMAT } <> 4418, 4903, 4830 "(Table)" "" }


I do not believe this is correct, but I'm not sure how to adjust this to make it correct.
Any suggestions?


Thank you All,
Shawn
Reply With Quote