Multiple IF condition
Hi Susan,
There are numerous ways of doing this. One way is:
{IF{=({IF{MERGEFIELD House}= Blue 1 0}+{IF{MERGEFIELD House}= Green 1
0})*{IF{MERGEFIELD Street}= Color 1 0}}= 1 "BLUE or GREEN" "NOT A MATCH"}
Cheers
"Susan" wrote in message
...
Would appreciate the proper syntax for the following "If Statement":
If (HOUSE = BLUE or GREEN) and (STREET = COLOR) say "BLUE or GREEN"
otherwise say "NOT A MATCH".
This is how far I've gotten,
{IF {= OR ({COMPARE {MERGEFIELD HOUSE} = "BLUE"},{COMPARE {MERGEFIELD
HOUSE}
= "GREEN"}, {COMPARE {MERGEFIELD STREET} = "COLOR"})} 1 "BLUE OR GREEN
COLOR" "NOT A MATCH"}
Thanks in advance
--
Susan
|