Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-10-2019, 11:52 AM
shawn.low@cox.net shawn.low@cox.net is offline "OR" condition within an IF Statement Windows 10 "OR" condition within an IF Statement Office 2016
Novice
"OR" condition within an IF Statement
 
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
 

Tags
multiple values in "if"



Similar Threads
Thread Thread Starter Forum Replies Last Post
&quot;OR&quot; condition within an IF Statement Adding a Table with an "IF" Statement shawn.low@cox.net Mail Merge 2 05-21-2019 09:49 AM
Convert Number to Text - To enter "AND" in between with different condition cltay87 Excel Programming 0 07-06-2018 12:56 AM
&quot;OR&quot; condition within an IF Statement Don't want if statement to return "false" mbesspiata Excel 2 06-06-2016 02:29 PM
&quot;OR&quot; condition within an IF Statement IF statement just generates text "MERGEFIELD" in document - what am I doing wrong? Eri Mail Merge 1 03-03-2012 03:03 PM
&quot;OR&quot; condition within an IF Statement How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft