Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF / AND option?
Yes it is possible with nested conditional fields.
{ IF { F1 } = "A"{ IF { F2 }="1""X"{ IF { F2 } = "2" "Y"{ IF { F2 } = "3" "Z"""}}}} |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF / AND option?
before I start all this I am looking to at a total of 30 different responses.
Can I next that many? "Greg" wrote: Yes it is possible with nested conditional fields. { IF { F1 } = "A"{ IF { F2 }="1""X"{ IF { F2 } = "2" "Y"{ IF { F2 } = "3" "Z"""}}}} |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF / AND option?
I would suggest that data manipulation such as this is best done in the data
source. I am not sure of the exact limit on nested fields, but you may be getting near it with the 30 different responses. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "jermsalerms79" wrote in message ... before I start all this I am looking to at a total of 30 different responses. Can I next that many? "Greg" wrote: Yes it is possible with nested conditional fields. { IF { F1 } = "A"{ IF { F2 }="1""X"{ IF { F2 } = "2" "Y"{ IF { F2 } = "3" "Z"""}}}} |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF / AND option?
See the example at http://www.gmayor.com/formatting_word_fields.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org jermsalerms79 wrote: before I start all this I am looking to at a total of 30 different responses. Can I next that many? "Greg" wrote: Yes it is possible with nested conditional fields. { IF { F1 } = "A"{ IF { F2 }="1""X"{ IF { F2 } = "2" "Y"{ IF { F2 } = "3" "Z"""}}}} |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No 'Save as' Option in Word 2003 | Microsoft Word Help | |||
How do I save information from option buttons like other form data | Microsoft Word Help | |||
how to group option buttons in word? | Microsoft Word Help | |||
Word Template and Macros (as an option on toolbar) | Microsoft Word Help | |||
option send to e-mail address (as attachment) unavailable | Microsoft Word Help |