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.
--
Amy E. Baggott

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson

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.
--
Cheers
macropod
[Microsoft MVP - Word]


"Amy E. Baggott" <(E-Mail Removed)> wrote in message news:911D4025-9410-46F8-AC5A-(E-Mail Removed)...
> 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.
> --
> Amy E. Baggott
>
> "I''m going crazy and I''m taking all of you with me!" -- Linda Grayson

[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