View Single Post
 
Old 07-18-2011, 04:30 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,374
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

Hi Rikil,

If the expression being tested has spaces in it, then yes, you do need the docuble quotes. You also need them for any output expressions that have spaces in them.

As for case-insensitivity, use something along the lines of:
{IF {MERGEFIELD A \* Upper} = "CORPORATION" {IF {MERGEFIELD B \* Upper} = "N" "True" "False"} "False"}
Basically, the '\* Upper' switch converts the mergefield contents to upper-case, which alloes the comparison to be done on an all-caps basis.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote