#1
|
|||
|
|||
Two conditions IF field
I need a field for using in a mail merge like:
IF Mergefield X="A" AND Mergefield Y="" then "Yes" else "No" Is there a way to do that with field code? Thanks!
__________________
Backup your original file before doing any modification. |
#2
|
||||
|
||||
There are many ways. For example:
{IF{MEGEFIELD X}= "A" {IF{MEGEFIELD Y}= "" "Yes" "No"} "No"} {={IF{MEGEFIELD X}= "A" 1 0}*{IF{MEGEFIELD Y}= "" 1 0} \# "'Yes';;'No'"} The second is simpler to implement once you start getting multiple AND/OR conditions to evaluate.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Works fine! Thanks!
__________________
Backup your original file before doing any modification. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sum with conditions | xling | Excel | 2 | 08-15-2017 12:16 AM |
Delete Tables using conditions from Drop Down Field | tejaspareek | Word VBA | 7 | 11-02-2014 10:24 PM |
6 conditions formula | paconovellino | Excel | 2 | 03-05-2012 06:45 AM |
3 Conditions | Laurie B. | Excel | 4 | 08-15-2011 10:27 PM |
how to set an equation with three conditions? | Jamal NUMAN | Word | 0 | 07-09-2011 06:05 AM |