Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 03-25-2024, 01:41 PM
TessaMurillo TessaMurillo is offline Multiple IF statement issue Windows Vista Multiple IF statement issue Office 2010
Advanced Beginner
 
Join Date: Mar 2024
Posts: 32
TessaMurillo has a little shameless behaviour in the past
Default

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!
Reply With Quote
 



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 IF statement issue 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
Multiple IF statement issue Using multiple conditions with an IF statement?? to show a yes/no value BlindMouse Excel 1 01-27-2016 12:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft