Nested If statments in word

[sarahisaacs]

Please can someone help me. I am trying to use if statements in word with no sucess.

I have an address block where address2 and address3 are sometime populated and sometimes not. So I want to say if address2 = " " then skip, If address3 " " then just display address2. If both address2 and address3 are not blank then display address2, address3. With a comma separating them.

This is what I have so far:
{if { MERGEFIELD ADDRESS3} = " " "{MERGEFIELD ADDRESS2}" "{MERGEFIELD ADDRESS2} {MERGEFIELD ADDRESS3}"}


I tried to add the comma:
{if { MERGEFIELD ADDRESS3} = " " "{MERGEFIELD ADDRESS2}" "{MERGEFIELD ADDRESS2}"","" {MERGEFIELD ADDRESS3}"}


But this doesn't work at all.



I haven't even got to the skip bit yet


Please can someone help


Thanks
Sarah

 

[alow]

First, I want to say good luck, and that working calculations in Merge Fields is something that I had spent tons of time on in the past, though it's been a while and I don't remember a lot of the specifics. All I really remember are the headaches involved (re-enactment). The only help I think I can offer you is this link about general IF statements in Word, and this one that seems more relevant to your situation.

 

[sarahisaacs]

Woo Hoo yes you have solved my problem thanks so much

 

[alow]

Glad I could be of assistance!