#1
|
|||
|
|||
using merge fields in "if then else" formula
I am trying to create an "if then else" formula in a mail merge but cannot find the correct syntax. I have tried:
{IF {MERGEFIELD LAST_CURRENT} = "" {MERGEFIELD LAST_HS} {MERGEFIELD LAST_CURRENT} } Obviously, the above doesn't work. Any assistance would be greatly appreciated. Last edited by mike0919; 07-29-2011 at 09:26 AM. Reason: Forgot one additional comment. |
#2
|
||||
|
||||
Hi Mike,
There's nothing obviously wrong with the field syntax. Are you sure none of the field braces were typed? If created manually, they must be created in pairs via Ctrl-F9. Also, are you sure your 'LAST_CURRENT' field actually outputs nothing for missing data (eg not a 0 or a space)?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
If Then Else in Word
You're correct, I typed the field braces.
I created the field using "ctrl f9" for the braces and it worked...but you knew that! Thank you. |
#4
|
|||
|
|||
Performing Calculations using Mail Merge Fields
I'm running into a similar problem, and hopefully you can help. I get a syntax error and do not understand why.
Here is the simple calculation I am trying to do: Cost / (90% * Rent), formatted with no decimals, where Cost = $3,000.00 Rent = $247.00 which should yield 13.495276653171390013495276653171 but formatted and displayed as 13. Here is the Word equation I entered: { =({MERGEFIELD Cost}/.9*{ MERGEFIELD Rent})) \# "0"} Why do I get a syntax error? |
#5
|
||||
|
||||
You have too many ')'! Your field should be coded along the lines of:
{={MERGEFIELD Cost}*{MERGEFIELD Rent}/0.9 \# "0"}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing "Fill-In" merge fields | vorm | Mail Merge | 0 | 07-27-2011 08:22 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
Excel 07 formating 17 cells "Need Formula" | Raner | Excel | 2 | 05-30-2010 02:07 PM |
"Microsoft Excel Application" missing in the "Component Services" on win08 | sword.fish | Excel | 0 | 02-26-2010 02:09 PM |
merge field formatting problem with "text to be inserted before" | wissam | Mail Merge | 0 | 12-13-2009 12:50 AM |