View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jermsalerms79
 
Posts: n/a
Default IF / AND option?

is there a way to return text based on two fields.

IF field 1 = a
AND field 2 = 1
THEN result = x

IF field 1 = a
AND field 2 = 2
THEN result = y

IF field 1 = a
AND field 2 = 3
THEN result = z

IF field 1 = b
THEN result = BLANK

Is this possible.