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

The following should work

{ IF{ =({ IF{ Mergefield House } = "BLUE" 1 0 } + { IF { Mergefield House }
= "GREEN" 1 0 } + { IF { Mergefield Street } = "COLOR" 1 0}) } = 2 "BLUE
OR GREEN" "NOT A MATCH" }

See 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


Susan wrote:
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

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