Microsoft Office Forums - View Single Post - [Solved] "IF" Staement(s) not Working properly

macropod · 05-10-2019, 03:24 PM

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’’.