Nested If Statements in Word 2007

[Amy E. Baggott]

Is there a way to nest If statements in Word or to use multiple conditions in
an IF statement? I have a cover letter that goes with an invoice, and I have
some conditional text that appears if the balance is negative. The three
possibilities are:

1. Balance is negative and date is <= the refund deadline, print "Refund to
follow"
2. Balance is negative and date is after the refund deadline, print "No
refund as deadline has passed."
3. Balance is 0 or positive, print nothing

Is there a way to do this in Word? Currently, I have an if statement based
on the balance, but I have to go in manually each year and change the letter
after the refund deadline, and I'd like it to be automatic.

 

[macropod]

Hi Amy,

Yes, you can nest IF statements - up to 20 levels if need be. Thus:
{IF{DATE \@ "YYYYMMDD"}> {DEADLINEDATE \@ "YYYYMMDD"} "No refund as deadline has passed." {IF{BALANCE}< 0 "Refund to follow"}}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Also, be careful to preserve the spacing indicated around the various expressions, otherwise you may run
into problems.

 

[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