Good morning,

I am wondering if someone can help me solve how to format an IF statement for multiple conditions? I am usually ok with this, but I am going around in circles with this one.
This is what I am trying to achieve -

IF (DAName1) has data, but (DAName2) doesn't, I need it to return "(DAName1) has been added to your policy as a delegated authority and can now access your information and make claims on your behalf"

IF (DAName1) and (DAName2) both contain data, I need it to return "(DAName1) and (DAName2) have been added to your policy as delegated authorities and they now have access to your information and can make claims on your behalf"

IF (DAName1) and (DAName2) are both blank, I need it to return nothing.

Any assistance would be greatly appreciated.

Is this for a macro or a field?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi it is for a field

Thanks for your help but I have now figured this out

The basic structure is
{If DAName1 {If DAName2 "Result for both DAName1 and DAName2" "Result for only DAName1"} ""}

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Thank you

To achieve your goal you need to use the IF function in Excel with multiple conditions
=IF(AND(ISBLANK(DAName1), ISBLANK(DAName2)), ", IF(ISBLANK(DAName2), DAName1 & " has been added to your policy as a delegated authority and can now access your information and make claims from your name", DAName1&" and "&DAName2&" have been added to your policy as delegated authority and they now have access to your information and can make claims on your behalf"))
This formula works like this:

Checks if both (DAName1) and (DAName2) are empty. If both are empty, an empty string is returned.
If (DAName1) contains data and (DAName2) does not, a message is returned indicating that (DAName1) has been added.
If both (DAName1) and (DAName2) contain data, a message is returned indicating that both have been added.
Hope this helps!

Great thank you Tessa, much appreciated

That's all very well if you're using Excel, but Word has no ISBLANK field function. Your formula syntax is wrong for Word, too.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]