Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-10-2019, 03:24 PM
macropod's Avatar
macropod macropod is offline "IF" Staement(s) not Working properly Windows 7 64bit "IF" Staement(s) not Working properly Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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

There is no highlighting in your post.

Presumably, OPPORTUNITY_AFFILIATE_ID is the name of a field in your data source. In that case, you need a field construction like:

{IF«OPPORTUNITY_AFFILIATE_ID»= 4418 "Payday Loan, LLC dba Payday Money Centers, with its headquarters at 300 S. Harbor Blvd., Suite 500, Anaheim, California 92805, California Finance Lender License No. 603 6712 (referred to herein as ‘‘Broker’’) is acting as a broker to assist LoanMe, Inc., 1900 S. State College Blvd., Suite 300, Anaheim, CA 92806, California Finance Lender License No. 603K061 (‘‘Lender’’) in making your loan. By signing below, you acknowledge that you understand:
1. Broker is acting as a loan broker to help Lender make your loan. This assistance to Lender may include obtaining information and documents necessary for Lender to make your loan. 2. Broker will receive $300 from the Lender as compensation for brokering your loan.
2. Broker will receive $750 from the Lender as compensation for brokering your loan.
3. The terms and conditions of your loan are fully set forth in the following Promissory Note and Arbitration Agreement you will sign when the loan is made. You should read that loan agreement and all other documents carefully. You are under no obligation to make the loan if you do not wish to sign the loan documents."}

Note 1: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, the chevrons (i.e. '« »') are part of the actual mergefields - which you can insert from the 'Insert Merge Field' dropdown (i.e. you can't type or copy & paste them from this message, either). The spaces represented in the field construction are all required.

Note 2: You cannot use double quotes as part of the output of an IF test. Hence the paired single quotes for ‘‘Broker’’ and ‘‘Lender’’.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
@dynamic document, @if statements



Similar Threads
Thread Thread Starter Forum Replies Last Post
Presentation will not print properly in "Notes" layout mnt23 PowerPoint 4 08-07-2018 06:53 AM
"IF" Staement(s) not Working properly Word 2014: WPerfect 6.x full-justification "stops working" dan_1 Word 12 01-24-2017 12:43 PM
"IF" Staement(s) not Working properly Is there a free download of a"working" PowerPoint 2003, not just a viewer. oldtrout PowerPoint 1 01-10-2016 01:23 AM
"IF" Staement(s) not Working properly 2007 Calendar - How do I show "working offsite" but available for phone meetings? Stan Outlook 2 08-16-2011 09:30 AM
"IF" Staement(s) not Working properly 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:09 AM.


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