Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
If "Yes" then "Yes or round as percentage
I am trying to import data from Excel into a Word document via mail merge.
All data in Excel is derived via a formula. One field Target is giving me trouble because is may be a percentage e.g.98.5%, a Yes/No. or Null. I have tried If Then and nothing seems to work to get the results I need. If the value is Yes, then I need it to state Yes, If it is a percentage, I need it to format as a percent and round to the 1st decimal. If it is null, I need it to state "N/A" Incidentally, I do not understand the merge switch concept and why it seems to toggle between three states, then two. Resources for this would be appreciated as well. Thanks -- qwerty |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
email merge with multiple recipients in "To", "CC" & "BCC" | Mailmerge | |||
I can't "Open" a downloaded template. Only "Save" and "Cancel" | Microsoft Word Help | |||
What does "char" "char1" "char2" mean in styles in Word? | Microsoft Word Help | |||
Word: 'track changes": have "changed by" rather "del." and "inser | Microsoft Word Help | |||
The "Symbol" under "Insert" disappeared and replaced by "Number" | Microsoft Word Help |