#1
|
|||
|
|||
"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 |
#2
|
||||
|
||||
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] |
Tags |
multiple values in "if" |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Don't want if statement to return "false" | mbesspiata | Excel | 2 | 06-06-2016 02:29 PM |
IF statement just generates text "MERGEFIELD" in document - what am I doing wrong? | Eri | Mail Merge | 1 | 03-03-2012 03:03 PM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |