![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2019: How to apply if statement for multiple values? | Jamal NUMAN | Excel | 2 | 02-27-2021 01:11 AM |
![]() |
IanT | Mail Merge | 4 | 01-15-2021 03:13 AM |
Multiple Projects in Multiple timelines Issue | szimmer100 | Project | 0 | 11-12-2019 12:11 PM |
Converting a Select statement in Excel to an update statement | shabbaranks | Excel Programming | 5 | 10-31-2018 11:47 PM |
![]() |
BlindMouse | Excel | 1 | 01-27-2016 12:19 AM |