Thread: [Solved] Multiple IF statement issue
View Single Post
 
Old 03-21-2024, 02:01 PM
Ren1975 Ren1975 is offline Windows 10 Office 2010
Novice
 
Join Date: Mar 2024
Posts: 9
Ren1975 is on a distinguished road
Lightbulb 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.
Reply With Quote