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

Hi jermsalerms79,

You can nest a maximum of 20 IF tests in Word. However, you don't
necessarily have to nest that many to get the desired result. If you post
back more details of what you're working with and what you're trying to
achieve, alternative ways of catering for your 30 combinations can probably
be found.

Cheers


"jermsalerms79" wrote in message
...
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.