Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 12-10-2019, 09:43 PM
macropod's Avatar
macropod macropod is offline &quot;OR&quot; condition within an IF Statement Windows 7 64bit &quot;OR&quot; condition within an IF Statement Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

You could use any of:

{IF{MERGEFIELD Opportunity_Affiliate_ID_Number}= 4418 "" {IF{MERGEFIELD Opportunity_Affiliate_ID_Number}= 4903 "" {IF{MERGEFIELD Opportunity_Affiliate_ID_Number}= 4830 "" "(Table)"}}}

or:

{QUOTE{SET Val {MERGEFIELD Opportunity_Affiliate_ID_Number}}{IF{Val}= 4418 "" {IF{Val}= 4903 "" {IF{Val}= 4830 "" "(Table)"}}}}

or:

{QUOTE{SET Val {MERGEFIELD Opportunity_Affiliate_ID_Number}}{IF{IF{Val}= 4418 1 0 }+{IF{Val}= 4903 1 0}+{IF{Val}= 4830 1 0}= 0 "(Table)"}}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
multiple values in "if"

Thread Tools
Display Modes


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 04:16 PM.


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