Thread: [Solved] Two conditions IF field
View Single Post
 
Old 06-06-2021, 03:43 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote