IF... THEN... ALSE...

A

abeyetev

What if I would like to use 3 options in the "IF... THEN... ALSE..." Rule
Exemple:
if state=NY insert New your, and if state=NJ insert New jersey, and if CA
insert California
 
G

Graham Mayor

Use a string of IF fields one immediately after the previous.
{IF {Mergefield State} = "NY" "New York"}{IF {Mergefield State} = "NJ" "New
Jersey"}{IF {Mergefield State} = "CA" "California"}etc

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a dynamic master file 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
How to Import Formatted text as new Slides in PowerPoint 0
How to insert Certificated digital signature in Word for Mac 0
Vlookup into 2 columns 2
NEED HELP !!!!! Add another formula to the Mail Merge Forumla IF 1
CONDITIONAL SUM FOR MULTIPLE CRITERIA IN SINGLE RANGE 1
How to insert HTML into an Outlook 2021 email 0

Top