![]() |
#7
|
|||
|
|||
![]()
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! |
|
![]() |
||||
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 |