Multiple IF statement issue
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.
|