Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2008

Tip: Looking for answers? Try searching our database.

If with And

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dee - 19 Feb 2008 14:27 GMT
Hi,
Am struggling with inserting:
no symbol if the field is blank (works fine)
if two conditions are true, display one symbol, otherwise another (doesn't
work)

Here is my syntax:

{symbol{if{=and {mergefield one} < 120 {if {mergefield 2} < 70 74 76} }} \f
wingdings}

Any help would be really appreciated!
Signature

Thanks!

Dee

Graham Mayor - 19 Feb 2008 15:10 GMT
If I understand correctly, you need both field results to be true to insert
one character or the other if not? Then see below. Note that the correct
spaces are crucial

{ Symbol { IF{ =({ IF{Mergefield One } < 120 0 1 } + { IF{ Mergefield Two }
< 70 0 1 }) } > 1 74 76} \f "Wingdings" }

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi,
> Am struggling with inserting:
[quoted text clipped - 8 lines]
>
> Any help would be really appreciated!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.