![]() |
|
#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 Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 |
Multiple actions in an IF statement
|
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 |
Using multiple conditions with an IF statement?? to show a yes/no value
|
BlindMouse | Excel | 1 | 01-27-2016 12:19 AM |