How to use a contains formula inside of an "If...then" formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brad - 31 Mar 2004 16:38 GMT

I work for a hospital & I am trying to print out the new
residents and fellows contracts. I have the contract that
pulls from mail merge fields however the salary field is
not available. It is going to be the same for all
residents and fellows for example:

39021.00 Resident 1st year
40928.00 Resident 2nd year.

Therefore I wanted to use an "if then..." to enter the
appropriate salary depending upon the resident's staff
category which is an available merge field. I figure i
mauy need to use a few if thens.. because you can only
nest 2 deep, I beleive.

Any assistance would help.

Reply to this Message

Graham Mayor - 31 Mar 2004 17:20 GMT

You can nest more than two deep, but the deeper you go the more difficult it
becomes to keep track of. An alternative possibility is to daisychain the
conditional fields on the same line with no spacing between them
{IF {Mergefield Category} = "Resident 1st year" "39021.00"}{IF {Mergefield
Category} = "Resident 2nd year" "40928.00"}etc. As the result is based on
only one piece of information, you will get either a result or nothing.
Change the fieldname from category and the results to exactly reflect the
fieldname and the contents.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I work for a hospital & I am trying to print out the new
> residents and fellows contracts. I have the contract that
[quoted text clipped - 12 lines]
>
> Any assistance would help.

Reply to this Message