I need to specify multiple conditions with an IF field. How?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EBB - 05 Oct 2004 14:41 GMT

I am trying to build in a multiple IF field. i.e. if state=AL and
license=medical then use this address, else use another address. HOW?

Reply to this Message

Greg - 05 Oct 2004 15:40 GMT

EBB,

You can do this with nested IF fields. As an example:

{IF{S} = "AL"{IF{L} = "Medical"{A1}{A2}}{A2}}

Where {S} is your state mergefield
{L} is your license mergefield
{A1} is the address 1 mergefield
{A2} is the address 2 mergefield.

>-----Original Message-----
>I am trying to build in a multiple IF field. i.e. if state=AL and
>license=medical then use this address, else use another address. HOW?
>.

Reply to this Message